Macola Buying to Stock Ratio 1

[HigginsT]

Hello,
We purchase rolls of tape as per each, however I need this converted to inventory in inches (648") after a PO is processed. Looking at the attached screen capture, I've tried every variable possible, within the "To Stock Ratio" box, to convert the purchase number (1pc) to come out to the stocking number 648 inches. But I cant make it work. Can anyone please help me with this task?
I've been tiring for two weeks but cant make it work properly.

 

[dgillz]

You should put 648 in this field. You purchase and receive 1 and 648 will be put into stock.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[HigginsT]

Dgillz,
Thanks. I don't see which field you are referring to however, at different times, I tried adding 648 to both of the "to stock ratio" fields. The inventory value never changes, it always sees 1 unit, as in the per roll unit of (1).

 

[dgillz]

In the purchase to stock ration, put 648. Then create a PO, then print it and receive a qty of 1. It'll work. The ratio of 648 is captured on the PO line, so receiving an existing PO will not work.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[HigginsT]

Dgillz,
That worked thank you! It seems the key was creating a "new" PO#. During our previous testing we used a previous/prior PO to test the theory so, it didn't work.


Thank you,
Troy