cancel
Showing results for 
Search instead for 
Did you mean: 

Need to have correct unit price in Commercial Invoice

0 Kudos

Hi Friends,

Generally we have a Parent item and two child item in Feeder system ,For example if Parent item have Net Value $100 child item have value 0 ,once its transferred to GTS the value of Parent item becomes 0 and child item value is proportionately divided between two child item.and the Commercial invoice ( output ) shows total quantity and the value of Parent item .Unit price =Total Value of Parent/ delivered quantity.

Now in some instance the child item is delivered partially.The quantity of Parent is 20 unit child item is delivered as 4,12,4 qty ,both are delivered separately..

Issue is appearing that since there is separate Customs Declaration document for Parent item=20 Qty and Child item 4 qty,12 qty and 3 qty .

In Commercial Invoice of Child item where there is 4 qty the Net value is appearing as $100 the unit price is $100/4 = $25 ,whereas for 12 qty  the net value appearing is $100 unit price is $100/12 = $8.33 , as per this logic there is discrepancy in unit price of same material but with different quantity.

We want to restructure the unit price such that it should be $100 /20 qty=$5

In commercial Invoice 1  where 4 quantity is delivered value should be 4qtyX$5=$20

In commercial Invoice 2  where 12 quantity is delivered value should be 12qtyX$5=$60

commercial Invoice 3  where 3 quantity is delivered value should be 4qtyX$5=$20

Can the experts have there comments how to restructure this.

Thanks & Regards

Amit

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member215181
Active Contributor
0 Kudos

Hi Amit,

I find it impossible to follow your description of the problem.  For example, you don't say from which system the Commercial Invoice is created, and what the "Child Items" are - are they batch-splits, or something else?  And what Billing Relevance value is being used in the Item Category?  Is it 'A' or 'M', or something different?

Perhaps if you could simply refer to the quantities and values that you see in the ERP feeder system and in the GTS Export Declaration, it would be easier.

Let's suppose that your ordered quantity of 20 has so far been partially delivered as quantity 4, and then (later) quantity 12.  What quantities and values do you see in the Billing Document and Declaration?

Regards,
Dave