Is there a way designate a specific inventory offset account (expired inventory, for example) for an entire batch? It's very slow an inefficient to change the GL account line by line !
*This post is locked for comments
Update to 2013. There is a Reason Code field in Inventory Adjustments. When you create the reason codes, you assign specific offset accounts to the reason code. So you can have different accounts for items scrapped, vs items found, vs items given to sales reps.....et cetera
I just completed a little bit of Modifier and VBA on the Adjustment Screen. A added a field on the screen that allows a user to specify a "purpose" for the adjustment (e.g. Issue to Marketing, Scrap). Then as the user is adding items to the scrolling window, the distribution is updated from an Extender Table with the "purposes" and the appropriate GL Codes (the Extender data is maintain by Finance). Seems to work well.
Tim
Hi,
Because you mentioned inventory offset account, I presume you are making an inventory adjustment transaction. I would probably modify the the IV10001.IVIV0FIX field to equal the index of the account you want. The update statement would look something like this:
UPDATE IV10001
SET IVIVINDX = 120 --whatever the index of the account you want
FROM IV10001 INNER JOIN
IV10000 ON IV10001.IVDOCNBR = IV10000.IVDOCNBR
AND IV10001.IVDOCTYP = IV10000.IVDOCTYP
WHERE (IV10000.BACHNUMB = 'Your Batch Number')
AND (IV10000.IVDOCNBR = 'Your Document Number')
AND (IV10000.IVDOCTYP = 1)
Document Type 1 is an inventory adjustment (vs a variance which is doc type 2)
Kind regards,
Leslie
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (