Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP(ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting. New visitors, please click here!
I have query that pulls data from the PO Header and PO Details table with the PO date as parameter. One thing i have noticed that if a PO has been received subsequent to the PO date parameter, it still shows as received instead of outstanding.
I am basing this information on POPORL.Extreceive.
Correction, EXTRECEIVE is the extended quantity, but I'm not sure what you're doing.
In my Cost run report, I am trying to capture all the PO outstanding vs PO received amounts based on the PO date.
So for example, lets say we have PO100 with the following information:
PO PO Date Quantity UC Extended
100 1/1/2018 1 10 10
Lets say in 3/1/2018, I receive all 10 items on PO100 but when I run the query as of 2/1/2018, PO100 will already show 10 as received and 0 as outstanding even though it was received 1 month later in Accpac.
In my query, I am using EXTRECEIVED as the received amount and EXTENDED as the outstanding amount.