Skip to Content
0

Price List on Purchase Invoice (A/P Invoice)

Nov 21, 2016 at 11:20 PM

105

avatar image

Hello,

I'm not very good doing formated searches on creating documents,

I currently have a fms to search for the price of the item on my price list table:

SELECT T2.[Price] FROM OCRD T0  INNER JOIN OPLN T1 ON T0.ListNum = T1.ListNum INNER JOIN ITM1 T2 ON T1.ListNum = T2.PriceList 
WHERE T0.[CardCode]  = $[$4.0.1] AND  T2.[ItemCode] = $[$38.1.0]

I want to keep that, but I also need to be able to automatically use another price list if the total of ITEMS perteining to one group of ITEMS is more than 500

For example if I have this lines on my purchas invoice

P001 ITEM A (PAPER GROUP) 110 1.50
P002 ITEM B (PAPER GROUP) 400 1.50
C001 ITEM C (CARDBOARD GROUP) 500 2.10

I need that the fms automattically change the price on ITEM A and ITEM B from 1.50 to 2.50 (Price that would be stored on another list) it would look like this

But the ITEM C to remain on price 2.10 pertaining to the main list.

It would look like this:

P001 ITEM A (PAPER GROUP) 110 2.50
P002 ITEM B (PAPER GROUP) 400 2.50
C001 ITEM C (CARDBOARD GROUP) 500 2.10

All the purchase invoices (A/P Invoice) I made are pulled from existing Purchase Orders

OR

If an FMS can't sum all materials before creating then It would be enough to just use the other price list if the amount on the line is more than 500 and the group is PAPER

for example

P001 ITEM A (PAPER GROUP) 110 1.50
P002 ITEM B (PAPER GROUP) 510 1.50
C001 ITEM C (CARDBOARD GROUP) 550 2.10

The FMS would only change price on the line with quantity larger than 500 and on a specific group

it would look like this

P001 ITEM A (PAPER GROUP) 110 1.50
P002 ITEM B (PAPER GROUP) 510 2.50
C001 ITEM C (CARDBOARD GROUP) 550 2.10

Any of those two scenarios would work, scenario A would be better but I really can't get my head arround that on how it would work.

Would really appreaciate the help.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Pradnya S Nov 25, 2016 at 12:40 PM
0

Hi,

I doubt this complex scenario will be catered with the help of FMS. you will have to go for SPTN. In this case document will be validated for the total quantity per group and with the appropriate message, user will be prompted to enter a price.

Regards

Pradnya

Share
10 |10000 characters needed characters left characters exceeded