Skip to Content
author's profile photo Former Member
Former Member

Price column is blank on GRPO upload through XML

Dear SDK Forum Members,

We are trying to upload GRPO transaction linked to PO through XML, all values import fine but for the Price. The price column is blank.

Need your assistance on this. The following is the sample XML file.

<?xml version="1.0" encoding="UTF-16" ?> 
- <BOM>
- <BO>
- <AdmInfo>
  <Object>20</Object> 
  <Version>2</Version> 
  </AdmInfo>
- <Documents>
- <row>
  <DocNum>17</DocNum> 
  <DocType>dDocument_Items</DocType> 
  <HandWritten>tNO</HandWritten> 
  <Printed>tNO</Printed> 
  <DocDate>May 29 2008 7:29PM</DocDate> 
  <DocDueDate>May 29 2008 12:00AM</DocDueDate> 
  <CardCode>V1010</CardCode> 
  <CardName>Far East Imports</CardName> 
  <Address>300 Elm Street Suite 300 Los Gatos CA 988778 USA</Address> 
  <DocCurrency>USD</DocCurrency> 
  <DocRate>0.000000</DocRate> 
  <DocTotal /> 
  <Reference1 /> 
  <Comments /> 
  <JournalMemo /> 
  <PaymentGroupCode>2</PaymentGroupCode> 
  <DocTime /> 
  <SalesPersonCode>2</SalesPersonCode> 
  <Confirmed>tYES</Confirmed> 
  <ImportFileNum /> 
  <SummeryType>dNoSummary</SummeryType> 
  <ContactPersonCode /> 
  <ShowSCN>tNO</ShowSCN> 
  <Series>13</Series> 
  <TaxDate /> 
  <PartialSupply>tYES</PartialSupply> 
  <DocObjectCode>20</DocObjectCode> 
  <DiscountPercent>0.000000</DiscountPercent> 
  <RevisionPo>tNO</RevisionPo> 
  <BlockDunning>tNO</BlockDunning> 
  <Pick>tNO</Pick> 
  <PaymentMethod /> 
  <PaymentBlock>tNO</PaymentBlock> 
  <MaximumCashDiscount>tNO</MaximumCashDiscount> 
  <WareHouseUpdateType>dwh_Stock</WareHouseUpdateType> 
  <Rounding>tNO</Rounding> 
  <DeferredTax>tNO</DeferredTax> 
  <NumberOfInstallments>1</NumberOfInstallments> 
  <ApplyTaxOnFirstInstallment>tNO</ApplyTaxOnFirstInstallment> 
  <DocumentsOwner>3</DocumentsOwner> 
  <DocumentSubType>bod_None</DocumentSubType> 
  <Address2 /> 
  <PayToCode /> 
  <UseShpdGoodsAct>tNO</UseShpdGoodsAct> 
  <IsPayToBank>tNO</IsPayToBank> 
  <DownPayment>0.000000</DownPayment> 
  <LanguageCode>3</LanguageCode> 
  <PickRemark /> 
  <SequenceModel /> 
  <UseCorrectionVATGroup>tNO</UseCorrectionVATGroup> 
  <VatPercent>0.000000</VatPercent> 
  </row>
  </Documents>
- <Document_Lines>
- <row>
  <LineNum>0</LineNum> 
  <ItemCode>X0004</ItemCode> 
  <ItemDescription /> 
  <Quantity>10</Quantity> 
  <ShipDate /> 
  <Price>650.000000</Price> 
  <PriceAfterVAT>650.000000</PriceAfterVAT> 
  <Currency>USD</Currency> 
  <Rate>0.000000</Rate> 
  <DiscountPercent>0.000000</DiscountPercent> 
  <VendorNum /> 
  <WarehouseCode>01</WarehouseCode> 
  <SalesPersonCode>2</SalesPersonCode> 
  <CommisionPercent /> 
  <TreeType>iNotATree</TreeType> 
  <AccountCode>_SYS00000000019</AccountCode> 
  <UseBaseUnits>tNO</UseBaseUnits> 
  <SupplierCatNum /> 
  <CostingCode /> 
  <ProjectCode /> 
  <BarCode /> 
  <VatGroup /> 
  <Height1>0.000000</Height1> 
  <Height2>0.000000</Height2> 
  <Lengh1>0.000000</Lengh1> 
  <Lengh2>0.000000</Lengh2> 
  <Weight1>0.000000</Weight1> 
  <Weight2>0.000000</Weight2> 
  <Factor1>1.000000</Factor1> 
  <Factor2>1.000000</Factor2> 
  <Factor3>1.000000</Factor3> 
  <Factor4>1.000000</Factor4> 
  <BaseType>22</BaseType> 
  <BaseEntry>17</BaseEntry> 
  <BaseLine>0</BaseLine> 
  <Volume>0.000000</Volume> 
  <VolumeUnit /> 
  <Width1>0.000000</Width1> 
  <Width2>0.000000</Width2> 
  <Address /> 
  <TaxCode /> 
  <TaxType>tt_Yes</TaxType> 
  <TaxLiable>tYES</TaxLiable> 
  <ShippingMethod>3</ShippingMethod> 
  <CorrectionInvoiceItem>ciis_ShouldBe</CorrectionInvoiceItem> 
  <CorrInvAmountToStock>0.000000</CorrInvAmountToStock> 
  <CorrInvAmountToDiffAcct>0.000000</CorrInvAmountToDiffAcct> 
  <WTLiable>tNO</WTLiable> 
  <DeferredTax>tNO</DeferredTax> 
  <NetTaxAmount /> 
  <NetTaxAmountFC /> 
  <LineTotal /> 
  <TaxPercentagePerRow /> 
  <ConsumerSalesForecast>tNO</ConsumerSalesForecast> 
  <ExciseAmount /> 
  <SWW /> 
  <DistributeExpense>tYES</DistributeExpense> 
  <ShipToCode /> 
  <RowTotalFC /> 
  <TaxOnly>tNO</TaxOnly> 
  <UnitPrice>650.000000</UnitPrice> 
  <LineStatus>bost_Open</LineStatus> 
  <LineType>dlt_Regular</LineType> 
  <ChangeAssemlyBoMWarehouse /> 
  </row>
  </Document_Lines>
  </BO>
  </BOM>

Thanks

Suda

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 15, 2008 at 10:47 AM

    Hi Suda 😊

    nice to meet you. thx for your nice email.

    what i would try in your xml is to remove linetotal - it's an empty tag.

    generally i would try to remove all empty tags.

    the next is that you use price, priceafvat, unitprice and they have the same value

    but you don't set the taxcode.

    maybe you should try your luck with setting only one price tag - start with price or unitprice.

    i hope it's a bit helpful - this xml imports are always tricky.

    lg David

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.