Who's On?

	Membership:
	Latest: Nethetip
	Past 24 Hours: 0
	Prev. 24 Hours: 2
	Overall: 5306

	People Online:
	Visitors: 256
	Members: 0
	Total: 256

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3290
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244

Reporting on Cancelled PO Lines with Multiple Distributions

1 Replies

0 Subscribed to this topic

1 Subscribed to this forum

Sort:

Author

Messages

Bob Canham

Veteran Member

Posts: 217

3/19/2014 5:55 PM

We are writing some reports on PO Line data out of our 9.0.1 S3 Procurement application and have run into a bit of a snag. The issue I have run into is if we partially cancel a PO line that had multiple quantity or amount distributions. Is there anywhere in the database where it states which distributions got cancelled?

For example you order 20 of an item at $10 Each. Using the Mult button, this line is split between 10 at Acct Unit 1 and 10 at Acct Unit 2. 7 are received, and the rest of the line is cancelled.

Is there anywhere in the database that stores which distribution will be invoiced and which will be cancelled? Or is it just a function of the match program (MA43) and it applies in distribution sequence order?

JonA

Veteran Member

Posts: 1162

3/20/2014 11:27 AM

MMDIST will show how the quantity is distributed between the two acct units. When a line has a partial cancel and there are multiple distributions (by amount or quantity) the PO cannot be released until the distributions are manually balanced in PO21.3. So as long as the PO is released MMDIST should show the new distribution.