frequency of IC283 in update mode vs no-update mode

We run our IC283 report along with our month-end report in update mode at the beginning of each month. We've instructed our staff to runt he report in non-update mode if the information is needed mid-month, for example.

What is your policy for IC283? What frequency do you run the reports in update mode?

We are concerned that when users run the report in update-mode mid-month - what is the impact...

Find more posts tagged with

Infor Lawson Supply Chain Management - Discussion

Comments

unknown

We do not run the IC283 - once the par is stocked, the item is expensed for us. As it's a 200 series report, I'm not sure if there's any negative to running in update mode, but this is likely better answered in a webchat with Infor.

jon-athey

We don't run IC283 either. It's our policy not to book expensed locations as assets. I believe running it in update mode just writes the location total value to the PAR_VALUE field in the ICLOCATION table. Running it in update mode outside of month end would affect any reports that used that field. Otherwise it will update again at the next month end.

jon-athey

I'll also add that you could secure the Update Par Value flag so your users can only run when = N. I worked with our Lawson security person in IT to do this with PO135 before I created a better RNI report in Crystal. It allowed our buyers to run their RNI report at any time without worrying about them running it in update mode.

kevinwheeler

Hi John, would you consider sharing your crystal report? Our team is stuggling with PO135, mostly with excessive runtime. If they had a Crystal report to run on demand, it would definitely be an asset to the overall process.

Jim Norbut

ditto for me on the crystal report......I think our folks might be interested in looking at it.

james.norbut@froedtert.com

jon-athey

Note that I had to change the file extension from .rpt to .doc for the forum to accept the file.

In the Details section expert I'm suppressing any receipts newer than 40 days. Our buyers only want to see the RNI if the receipt is 40 days or older.

Also, there's a subreport embedded that shows the buyer if there are any open cost messages for the PO line so they know an invoice has been entered but there's an issue. So when you change the report source to your server you'll need to change it for the main report and the sub.

[View:/cfs-file/__key/communityserver-discussions-components-files/54/RNI-Report-for-Buyers.doc:320:240]

0902111224323213.pdf

cpashley

Just curious - Who is responsible for maintaining your PO135 in your facilities? Is the Supply Chain or Purchasing department responsible for the reconciliation of the report?

Stace Webley

Hi Jon - Would you be willing to share the SQL behind this?

jon-athey

Sure. This the output when I click on "Show SQL Query".

SELECT "PURCHORDER"."BUYER_CODE", "BUYER"."R_NAME", "PURCHORDER"."COMPANY", "PURCHORDER"."PO_NUMBER", "PURCHORDER"."PO_CODE", "POLINE"."LINE_NBR", "POLINE"."ITEM", "POLINE"."DESCRIPTION", "POLINE"."ITEM_TYPE", "POLINE"."REC_QTY", "POLINE"."MATCHED_QTY", "POLINE"."ENT_BUY_UOM", "POLINE"."ENT_UNIT_CST", "POLINE"."ARCHIVE_QTY", "POLINE"."REC_ACT_DATE", "APVENMAST"."VENDOR_VNAME", "PURCHORDER"."LOCATION", "POLINE"."CLOSED_FL", "POLINE"."PO_NUMBER", "POLINE"."COMPANY", "POLINE"."PO_CODE"

FROM ("MMHPROD"."APVENMAST" "APVENMAST" INNER JOIN ("MMHPROD"."BUYER" "BUYER" INNER JOIN "MMHPROD"."PURCHORDER" "PURCHORDER" ON "BUYER"."BUYER_CODE"="PURCHORDER"."BUYER_CODE") ON "APVENMAST"."VENDOR"="PURCHORDER"."VENDOR") INNER JOIN "MMHPROD"."POLINE" "POLINE" ON (("PURCHORDER"."COMPANY"="POLINE"."COMPANY") AND ("PURCHORDER"."PO_NUMBER"="POLINE"."PO_NUMBER")) AND ("PURCHORDER"."PO_CODE"="POLINE"."PO_CODE")

WHERE "POLINE"."CLOSED_FL"='N'

ORDER BY "PURCHORDER"."BUYER_CODE", "APVENMAST"."VENDOR_VNAME", "PURCHORDER"."PO_NUMBER", "POLINE"."LINE_NBR"

LN 10.7 Multi Site Activation for existing LN Customers with Peter.mp4

jon-athey

Tammy- our buyers investigate/reconcile RNI 40 days or older. Until it reaches that point they don't see it. AP may do some reconciliation also.

unknown

Hi Jon - What is the difference between this and the PO278 (RNI Aging)? Or does it just predate the PO278?

For the group: AP works vendor statements and are responsible for the dollars on the RNI. But the Buyers are also responsible for their open orders so there's a fair amount of overlap.

jon-athey

Kat- it's very similar to PO278. I definitely created it before I knew PO278 existed. Mine is a little prettier and easier to read imho. I schedule it to run every Monday morning and I have and additional report that each buyer receives showing their RNI aging graphically.

[View:/cfs-file/__key/communityserver-discussions-components-files/54/RNI-Aging-Analysis.pdf:320:240]

Copyright © 2025 Infor. All rights reserved.