Hi All,
Â
We are required by our European customers to display weights of our goods on our Sales Orders and also require a SUM of all line weights to be displayed on the Sales Order Entry screen as we calculate our fright costs based on weight.
Â
As you are entering a Part (in Part Maintenance) you have the opportunity to input a weight for it as 'Unit Net Weight'. This is the weight that we need to use.
Â
When you input a Sales Order you are adding various Parts & quantities onto this order. Once you have finished adding the parts you will save it & then Print an Order Acknowledgement to either the screen or a printer. This Order Acknowledgement needs to display the weight of the parts & then the Total Weight.
Â
e.g.
Sample order for:         10 x Part A
                                   20 x Part B
                                   10 x Part C
Â
If we said that each;Â Â Â Â Â Â Part AÂ weighs 0.15kg
                                    Part B weighs 0.25kg
                                    Part C weighs 2.5kg               (these weights would all be stored in the Part screen)
Â
Â
We then need the acknowledgement to show:-
Â
10 x Part A
           weight 1.5kg
20 x Part B
           weight 5.0kg
10 x Part C
           weight 25kg
Â
Total Weight = 31.5kg
Â
Â
We then use this weight, as displayed on the acknowledgement, to charge our customer the relevant delivery cost based upon the actual weight.
Â
The weights are also displayed on all quotes, proformas, invoices & credit notes in the same manner as the acknowledgement.
Â
Â
I believe that some basic calculation should be already in place in Vantage, as all weights must be shown as individual 'transaction line weights' for Intrastat purposes. Whenever you despatch goods to a customer within another EC Member State the invoice MUST show certain information. This includes our VAT number, the customer's VAT number, the country of destination, the commodity code of each item/line, the weight of each line. This has to be on every EC invoice & credit note.
Â
In addition to this, the monthly Intrastat Report, reports back individual lines from every EC invoice & credit note. This report shows the invoice number, the country of destination, the delivery terms, the weight, the mode of transport, the nature of the transaction, commodity code and country of origin. BUT it shows it based upon every line. So even if you have 4 lines on an invoice & they were all the same commodity code, it wouldn't 'lump' them all together for the report & show you a total weight for a commodity code. It would show 4 individual lines on the Intrastat Report, that is the requirement.
Â
So really, if Vantage is doing this, it should be able to do our order weight requirement quite easily as the basic function is so similar.
Â
It would be best if the Sales Order Entry Screen had a field that accumulated with the more lines/items added, therefore, it would eliminate a sales person printing to screen to get the total order weight.
Â
Has anyone done anything like this in the past?
Â
I look forward to any replies/advice you may have - we're new at Vantage and have only started inputting data etc.
Â
Thanks,
Â
CHRIS THOMPSON
[Non-text portions of this message have been removed]
Â
We are required by our European customers to display weights of our goods on our Sales Orders and also require a SUM of all line weights to be displayed on the Sales Order Entry screen as we calculate our fright costs based on weight.
Â
As you are entering a Part (in Part Maintenance) you have the opportunity to input a weight for it as 'Unit Net Weight'. This is the weight that we need to use.
Â
When you input a Sales Order you are adding various Parts & quantities onto this order. Once you have finished adding the parts you will save it & then Print an Order Acknowledgement to either the screen or a printer. This Order Acknowledgement needs to display the weight of the parts & then the Total Weight.
Â
e.g.
Sample order for:         10 x Part A
                                   20 x Part B
                                   10 x Part C
Â
If we said that each;Â Â Â Â Â Â Part AÂ weighs 0.15kg
                                    Part B weighs 0.25kg
                                    Part C weighs 2.5kg               (these weights would all be stored in the Part screen)
Â
Â
We then need the acknowledgement to show:-
Â
10 x Part A
           weight 1.5kg
20 x Part B
           weight 5.0kg
10 x Part C
           weight 25kg
Â
Total Weight = 31.5kg
Â
Â
We then use this weight, as displayed on the acknowledgement, to charge our customer the relevant delivery cost based upon the actual weight.
Â
The weights are also displayed on all quotes, proformas, invoices & credit notes in the same manner as the acknowledgement.
Â
Â
I believe that some basic calculation should be already in place in Vantage, as all weights must be shown as individual 'transaction line weights' for Intrastat purposes. Whenever you despatch goods to a customer within another EC Member State the invoice MUST show certain information. This includes our VAT number, the customer's VAT number, the country of destination, the commodity code of each item/line, the weight of each line. This has to be on every EC invoice & credit note.
Â
In addition to this, the monthly Intrastat Report, reports back individual lines from every EC invoice & credit note. This report shows the invoice number, the country of destination, the delivery terms, the weight, the mode of transport, the nature of the transaction, commodity code and country of origin. BUT it shows it based upon every line. So even if you have 4 lines on an invoice & they were all the same commodity code, it wouldn't 'lump' them all together for the report & show you a total weight for a commodity code. It would show 4 individual lines on the Intrastat Report, that is the requirement.
Â
So really, if Vantage is doing this, it should be able to do our order weight requirement quite easily as the basic function is so similar.
Â
It would be best if the Sales Order Entry Screen had a field that accumulated with the more lines/items added, therefore, it would eliminate a sales person printing to screen to get the total order weight.
Â
Has anyone done anything like this in the past?
Â
I look forward to any replies/advice you may have - we're new at Vantage and have only started inputting data etc.
Â
Thanks,
Â
CHRIS THOMPSON
[Non-text portions of this message have been removed]