Dynamics GP

April 2009 - Posts

• Posting Sequences

  All you 'best practices' people out there are going to have to turn your head for a minute. Of couse if you have a better idea, I'll listen... Be aware that the techniques that I discuss here are version specific, and are not even guaranteed to work in different service packs.   I often need to gather data and do something with it as a use posts data. For instance, if a user posts a Sales Transaction Entry, I need to do things with the data. This post will document the posting order of different types of transactions. GP9, edited 11/2009 Sales Order Creation Order Header inserted in Open Order Line inserted in Open   Transfer Sales Order To Invoice Inv Header inserted in Open Inv Line inserted in Open Order Header inserted in history Order Line inserted in history Order Line deleted from open Order Header deleted from open Post Invoice Inv Header inserted in history Inv Line inserted in history Inv Line deleted from open Inv Header deleted from open GP10 Posted Apr 30 2009, 01:13 PM by Steve Gray with 1 comment(s)

• Lotted Items Workflow in Dynamics GP

  In order to do any reporting or work with lotted items it's important to understand how the data flows through the tables.   Lotted item workflow The item is in IV00101, ITMDRKOP = 3 NOTE: All quantities here are 'each' in IV00300 and SOP10201 On receipt, a line is added to IV00300. QTYRECEVD = quantity recieved QTYSOLD = 0 ATYALLOC = 0 When a sales order is created:  the IV00300.ATYALLOC = the sales order amount  A line is added to SOP10201 for each lot reservation. When an order is transferred to invoice:  The line in SOP10201 is updated to refer to the invoice When an invoice is posted:  The quantity moves from ATYALLOC to QTYSOLD in IV00300  The lines for that document REMAIN in SOP10201, but are flagged as POSTED   Posted Apr 22 2009, 05:49 PM by Steve Gray with no comments