MantikiFeed - Sales

Standard sales

Sales are split into two tables in MantikiFeed.

dbo.sales

dbo.sales_payment

Payment table has these specific rules to follow.

1. If the payment method is any of these:  "exchange", "wine_bank_interest", "promotional_credit" we do not want to show the payment in the payment table.
2. Tax rules for discounts:

   1. sales
      goods_discount_inc_tax includes promotional_credit amount
      goods_discount_tax includes promotional_credit tax amount
      promotional_credit amount is subtracted from the goods_net_inc_tax 
      promotional_credit tax amount is subtracted from the goods_tax

   2. sales_payment
      No entry for the promotional_credit amount in the sales payment table

Preorders

Preorders have some specific rules to follow.

1. The dbo.sales_payment table must include both the initial payment of the deposit as an entry for eg £12 and upon redemption of the balance, there must be a second entry for the deposit as it is used as part payment for the balance.
2. Where multiple items are preordered, the deposit should be credited all against the first item alphabetically, not spread evenly over the balance items:- ie the order with the suffix AA has all of the deposit credited against it.  Where the deposit paid is greater than the value of the balance of the first item, only the value of the first item is used from the pool of the deposit and the remainder is credited against the next alphabetical item and so on.  This has to be manufactured in the VW code as preorders in Mantiki work at a group level, not the level of the individual order.

Example below of a transaction where the deposit paid covers the price of one of the items fully

Stage 1, place preorder

dbo.sales

dbo.sales_payment

Stage 2, charge for balance

dbo.sales

dbo.sales_payment