This message was deleted.
# general
s
This message was deleted.
k
I want to say there's an accounting preference that's doing that to you
v
Sorry for the noob question, may I know what preference is that?
k
Don't know offhand - look through your preferences related to vendor bills.
USE PURCHASE ORDER RATE ON BILLS
Though - honestly it seems to not match your description
When the purchase order has multiple item receipts, the bill rate calculation depends on this setting. If this setting is enabled, the vendor bill rate uses the highest item receipt rate. If this setting is disabled, the vendor bill rate uses the purchase order rate.
Random question - does your SOAP request indicate what line the item it's adding to the bill is from?
Here's an excerpt from one that's working
Copy code
<tranPurch:itemList>
                    <tranPurch:item>
                        <tranPurch:item internalId="5588" xmlns:platformCore="urn:core_2019_1.platform.webservices.netsuite.com">
                            <platformCore:name>CL-200003P</platformCore:name>
                        </tranPurch:item>
                        <tranPurch:line>1</tranPurch:line>
                        <tranPurch:orderDoc>57418</tranPurch:orderDoc>
                        <tranPurch:orderLine>1</tranPurch:orderLine>
                        <tranPurch:quantity>1.0</tranPurch:quantity>
                        <tranPurch:units internalId="4" xmlns:platformCore="urn:core_2019_1.platform.webservices.netsuite.com">
                            <platformCore:name>EA</platformCore:name>
                        </tranPurch:units>
v
Sorry for the delayed response. Yes, it does indicate what line item.
<tranPurchline&gt;6&lt;/tranPurchline> <tranPurchorderDoc&gt;3170535&lt;/tranPurchorderDoc> <tranPurchorderLine&gt;6&lt;/tranPurchorderLine> <tranPurchquantity&gt;30.0&lt;/tranPurchquantity> <tranPurch:description>MOTOMIX ENG OIL 1 GAL CONT 4/CS</tranPurch:description> <tranPurchrate&gt;78.32&lt;/tranPurchrate> <tranPurchamount&gt;2349.6&lt;/tranPurchamount> <tranPurch:class internalId="1" xmlns:platformCore="urn:core_2017_1.platform.webservices.netsuite.com"> <platformCorename&gt;CDC&lt;/platformCorename> </tranPurch:class> <tranPurch:location internalId="3" xmlns:platformCore="urn:core_2017_1.platform.webservices.netsuite.com"> platformCore:name>CDC : 01 - CDC - Marble Hill</platformCore:name> </tranPurch:location>
I'm having issues with this item. The rate set for this item 78.32. But upon checking, it is being overridden by the Purchase price of the item which 78.30 causing a discrepancy.
k
Any scripts/workflows running?
v
I added runServerSuiteScriptAndTriggerWorkflows to false and same results