Can X3 handle purchases where cost is negative?

We run Sage X3 Update 9 Patch 9.

The cost of a product we buy is going negative.

This occurs from time to time because the product is a by-product- sometimes the supplier can sell the by-product, but other times they have to pay us to take it.

Depending on how extremely below zero the costs go, we may even start charging our customers a negative price. 

This will occur in both back-to-back and stock orders.

Can we support this in X3?

Thought process;

(The following all reads bizarrely to me, but here goes...;)

1. We raise PO to supplier with negative cost (-$20/ton)

2. Supplier sends us their invoice with negative cost (-$20/ton)

3. Supplier pays us based on their (negative) invoice. Is a supplier invoice therefore handled by Accounts Receivable rather than Accounts Payable functions in X3?

4. We receive goods into inventory at a negative cost (-$20/ton). Average Unit Cost (AUC) goes negative.

5. We create Sales Order with negative gross price (-$5) and negative cost ($-20) to Customer (Margin = +$15)

6. We create Sales Delivery with negative gross price (-$5) to Customer.

7. We create Sales Invoice with negative gross price (-$5) and negative cost ($-20) to Customer (Margin = +$15) 

8. We pay Customer based on our Sales Invoice with negative gross price. Is our Invoice to Customer therefore managed by our Accounts Payable rather than Accounts Receivable functions in X3?

Is this high level process supportable/logical/sensible in X3?

Steps 3 and 8 are standing out to me the most in consideration of "How will that work?"

Any advice would be appreciated. Thanks in advance.

Parents
  • 0

    We concluded that negative cost on PO and Sales Invoice and negative AUC is all as silly as it sounds.

    Our solution was;

    1. Raise PO to supplier with very small cost ($0.01/ton)

    2. Supplier sends us their invoice for very small cost ($0.01/ton)

    3. We pay Supplier invoice.

    4. We receive goods into inventory at a very small cost ($0.01/ton). Average Unit Cost (AUC) behaves perfectly (It trends down and appropriately. Not negative).

    5. We send AP invoice to Supplier (Setup as Customer) for the service of removing goods. 

Reply
  • 0

    We concluded that negative cost on PO and Sales Invoice and negative AUC is all as silly as it sounds.

    Our solution was;

    1. Raise PO to supplier with very small cost ($0.01/ton)

    2. Supplier sends us their invoice for very small cost ($0.01/ton)

    3. We pay Supplier invoice.

    4. We receive goods into inventory at a very small cost ($0.01/ton). Average Unit Cost (AUC) behaves perfectly (It trends down and appropriately. Not negative).

    5. We send AP invoice to Supplier (Setup as Customer) for the service of removing goods. 

Children
No Data