Price column is blank on GRPO upload through XML

[former_member583013]

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

[Nussi · Accepted solution]

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

[former_member583013 · Accepted solution]

We shall try your suggession and revert back.

Thanks