How to control the transporter bill

hansika

Hi all,

Our client is using NAV 2009 .

Scenario:

Most of the purchased goods received by transporters along with Supplier Delivery Challan. After that transporter send the bill with Supplier Delivery Challan Numbers . All financial postings - Purchase Inoive with Item Charge - Select the related GRN- post the Purchase Invoice are done by finance people.

Bill Details as mentioned below for month October :

Bill Date : 31/10/11
Transporter Code : High-Way Transporters
Transporter Bill No - 9876
Supplier DC No - DC-23/09-10-11 , DC-56/15-10-11, DC-87/21-10-11
Amount - 10000/-


And next month also Company received the purchased material through same transporter against different purchase orders.

Bill Details as mentioned below for the month of November.

Bill Date : 30/11/11
Transporter Code : High-Way Transporters
Transporter Bill No - 9976
Supplier DC No - DC-23/09-10-11 , DC-88/18-11-11, DC-89/25-11-11
Amount - 20000/-

If we observe in the second bill transporter included the already paid Supplier DC bill number - DC-23/09-10-11.

what client is asking is there any possibility to control this kind of transactions means which was already paid agasint GRN which we received . System should not allow to over book the transporter bill for the same DC .

Any advice ?


Thanks in advance.

navuser1

AFAIR !
I have done some development to track the Transporter Bill payment in the same scenario....

hansika

Hi navuser1,

Could you throw some light on this ?

Thanks in advance.

navuser1

What I have done (AFAIR) :

1. Bill received from transporters along with Supplier Delivery Challan Numbers
2. Create a Purchase Invoice along with Supplier Delivery Challan Numbers to book the liability first. Here You have to store the Supplier Delivery Challan Numbers in a Custom Table for tracking(duplicity) purpose .