Plus Community - for users of ACCPAC & Adagio accounting software

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!

Page 1 of 1 1
Topic Options
#53740 - 09/24/18 12:19 PM PO Outstanding vs PO Received
jnsimex
Member


Registered: 11/27/05
Posts: 370
Loc: Canada
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.

I am using the wrong field?

Top
#53741 - 09/24/18 12:23 PM Re: PO Outstanding vs PO Received [Re: jnsimex]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7665
Loc: Location, Location
EXTRECEIVE is the extended cost, so if the cost is zero, then so is this field.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53742 - 09/24/18 12:24 PM Re: PO Outstanding vs PO Received [Re: Jay Converse]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7665
Loc: Location, Location
Correction, EXTRECEIVE is the extended quantity, but I'm not sure what you're doing.
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53743 - 09/24/18 01:14 PM Re: PO Outstanding vs PO Received [Re: Jay Converse]
jnsimex
Member


Registered: 11/27/05
Posts: 370
Loc: Canada
Originally Posted By: Jay Converse
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:
Code:
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.

http://prntscr.com/ky9db7

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: