Page Comparison

Overview

Shipments use FIFO costing not the current cost on the product.
Reversals of shipments use the current cost on the product.
Salcrd use Costp1 

Refer document to FIFO cost How Readysell FIFO first in first out costing works in your business

...

...

Generate a Salcrd with the wrong Costing

1. Go to the shipment Sales>Shipments
2. Identify the product on the shipmentline along with the incorrect cost ex tax shipped along with the price it was sold at and make a note of these values. 
3. From the shipmentlines, click on 'Related' and select 'show product'
4. From the products module, click on the tab sites>movements
5. Populate onto the movements list view, the field of 'Balance'
6. Filter for balance > 0 there should not be anything
7. Note down the current quantity on hand and the cost ex tax
8. Go to the Suppliers tab on the product file and check the costp1 from the primary supplier and note it down. It should be the same as the each cost ex tax on the balance of stock in the movementsquantity on hand on the stockk movement.
9. Once you have noted down the above from the product movement, change the costp1 on the primary supplier to be incorrect cost that was on the original shipment
10. Click on Save
11. Generate a sales credit by doing a shipment backwards (do not credit the whole sale shipment) ensure to set the qty with a minus
    Check the cost ex on credit shipment you have just created
    In the field of 'customer order' reference back to the shipment no with the wrong cost  
12. Ensure Leave the default date on the Salcrd once you hit Complete on the shipment is the same date as the original invoice.
13. Now you need to do a Salinv to get the stock back to zero and see the result correctly on your sales report
14. Now go back to the product file and set the costp1 back to cost that it was originally for the primary supplier.
15. Insert a shipment and sell the product at the same price. Check the cost ex tax on the shipmentline is the correct FIFO cost not the costp1.
    If so, click on Complete and set the invoice date to be the date of the original incorrect invoice.
16. Allocate the salcrd against the salinv on the customers account (refer to your accounts person)

Case 2 - Goods shipped with wrong cost and has stock on hand

1. Go to the shipment and identify the product on the shipmentline along with the incorrect cost ex tax shipped along with the price it was sold at and make a note of these values. 
2. From the shipmentlines, click on 'Related' and select 'show product'
3. From the products module, click on the tab sites>movements
4. Populate onto the movements list view, the field of 'Balance'
5. Filter for balance > 0 there should a value greater than 0 select it.
6. Note down the qty in the balance field along with the each cost ex tax and the date and time for each movement for each line there is a balance.
7. Go to the Suppliers tab on the product file and check the costp1 from the primary supplier and note it down. It should be the same as the each cost ex tax on the balance of stock in the movements
   We now need to get the balance on the product back to zero before correcting the incorrect costing on the shipment
8. Insert a stock qty adjustment as a negative qty for the balance that was on the movement , with the same date and time as per the product movement balance .
   Select a stock qty adjustment type = short stock and in the description refer back to the shipment with the incorrect cost.
   Check the cost ex and value on the stock qty adjustment (should be costp1 not fifo)
9. Finalise the stock qty adjustment and check the product movement
   There should be no product movement
   Now to fix the incorrect costing on the incorrect shipment
10. Go back to the product and on the primary supplier set the cost to be the wrong each cost that it was on the original shipment that needed correcting
11. Click on Save on the product
12. Generate a sales credit by doing a shipment backwards (do not credit the whole sale shipment)
    Check the cost ex on credit shipment line you have just created is equal to the same incorrect cost on the original shipment.
    In the field of 'customer order' reference back to the shipment no with the wrong cost  
13. Ensure the date on the Salcrd once you hit Complete on the shipment is the same date as the original invoice.
    Now you need to do a Salinv to get the stock back to zero and see the result correctly on your sales report
14. as the sale shipment date as is.
15. Check the shipment lines for cost ex, margin, gp is the same as the original incorrect shipment values before you click on Complete
16. Click on complete to generate the salinv.
17. You may have more than 1 invoice with the wrong costing repeat the above steps for each incorrectly costed shipment before continuing. 

Adjustting the stock back to zero

1. Do a stock quantity adjustment for the total stock on hand now on the product.
2. Refresh your product view in case you have left this window open whilst doing the salcrd
3. Go to the product>sites>movements> note down the qty on hand now. Leave the costp1 on the primary supplier as is.
4. Click on Products>Stock Quantity Adjustment>New> insert the product and the quantity in backwards (to write the stock off) and check the cost ex
5. Ensure you select the correct Stock Qty Reason that points to the Stock Adjustment Variance gl account
6. All reduction in stock uses FIFO 

Set the costp1 back to the original cost on the primary supplier

1. Go back to the product file and set the costp1 back to cost that it originally was originally for the primary supplier.
2. Insert a shipment (DO NOT REVERSE THE NEGATIVE SHIPMENT JUST ENTERED ) and sell the product at the same price. Check the cost ex tax on the shipmentline is the correct FIFO cost not the costp1.
   If so, click on Complete and set the invoice date to be the date of the original incorrect invoice.

   Allocate the salcrd against the salinv on the customers account (refer to your accounts person)

   If you have more than one product to resolve you need to go back to either case 1 or case 2 before gettting the stock back to its original balance.
    another stock qty adjustment with the same qty on hand (Positive) as the previous stock qty adjustment
3. Check that the cost ex is the costp1 x qty adjusted
4. Finalise the stock qty adjustment

Now to get the stock on hand back to

...

original by selling the product

1. Sales>Shipments>New
2. Leave default date
3. Insert the product , the qty and check that the costex is the fifo costing not the incorrect cost.
4. Click on Complete to generate a invoice.
5. Check the product movements.