Transfer Order and Purchase Invoice

mkpjsr

Hi all,

We are using Transfer Order for sending some materials for certain processing to some vendors. The material goes at one go (with one challan) but it comes in parts (with 5-10 challan). And finally the vendor send us the Invoice containing the Labour Charges for all the processed materials that comes through different challan and we invoice them using Purchase Invoice. As we are using Transfer Order for receiving the materials from vendor so while invoicing we choose Type as G/L account and we select the appropriate Ledger to post the Bill Amount.

Now the problem is that, We want to link the Purchase Invoice with all the Transfer Receipt Nos. (5-10 challan) for which the invoice is sent by the vendor, so that we can easily know the material details for this invoice..

How should i proceed to resolve this issue??

Can I get some suggestion??

chengalasettyvsrao

In the Purchase invoice line you should use the Type = Item Charge instead of G/L account , then you can link with Transfer Receipts .

mkpjsr

chengalasettyvsrao wrote:

In the Purchase invoice line you should use the Type = Item Charge instead of G/L account , then you can link with Transfer Receipts .

Hi,
Thanx for the reply. Its a better solution.
But I am getting an error while posting the Purchase invoice.
I am attaching the error..

When we receive items through transfer order we dont enter Amount and i am entering the amount on purchase invoice, so after selecting all transfer receipt lines (using get transfer receipt lines) when i am clicking "Suggest Item Charge Assignment" button then Amount is not comming in "TO Assign" field...

What is wrong, can u please guide me..

mkpjsr

Hi, the error is resolved.
Actually I was choosing "Amount" in Item charge suggestion. If I am choosing "Equally" then its working fine.

Now, One thing I want to know that
"Once a Transfer Receipt Line" is linked with Item Charge" then the same Transfer Receipt Line cannot be used for linking with another Purchase Invoice Item Charge assignment.
OR
the record should not be visible in "Posted Transfer Receipt Line" list for selection so that user do not select the already linked line once again..


Is it possible???

chengalasettyvsrao

yes , You can do .

I can suggest the more you use standard functionality the less problems the client will have (there will be less potential for bugs).

mkpjsr

chengalasettyvsrao wrote:

yes , You can do .

how??, is it there or i have to customize it??

chengalasettyvsrao

The information given by you is insufficient , because Can you confirm that you will not add additional charges to the transfer receipt lines in future.Before you can decide any of this, you need to sit with a with client accountant what are all the charges they may add then these need to be in document. Once you have done that you can start to decide about the customization.

mkpjsr

This forum is so helpful just because of the kind of suggestion/help we get from you people.

chengalasettyvsrao wrote:

The information given by you is insufficient , because Can you confirm that you will not add additional charges to the transfer receipt lines in future.Before you can decide any of this, you need to sit with a with client accountant what are all the charges they may add then these need to be in document. Once you have done that you can start to decide about the customization.

Yes it has been discussed with the customer and in future there is no need to add additional charges the transfer receipt lines..

chengalasettyvsrao

mkpjsr wrote:

Yes it has been discussed with the customer and in future there is no need to add additional charges the transfer receipt lines..

I am not sure how the following information will help you. When it comes to solution when you post any Item Charge from Purchase invoice system will create the separate value entry. In the value entry table system will update the Item Charge No and Item Ledger entry No also . In this value entry line you have the item Ledger Entry No field also and the same way you have the ILE no in the Transfer Receipt line also. So you have to filter on the Documet type field where ( Document type =transfer Receipt) in the Value entry table and if the Item Chage No <> ‘’ then select the Item Ledger entry No . Then the same Item Ledger No is available in the Trasfer Receipt Line also as Item Rcpt. Entry No. Don’t show that Document No (ILE No) when user open the Item Charge assignment .

mkpjsr

Can u please guide me.. I am not able to map the fields from Transfer Receipt Line, Value Entry and Item Ledger Entry tables for filtering. Also where I need to write the code..

kmkaot

It is wrong to apply the charges on quantity basis.
your costing goes wrong..