4. Invoices‎ > ‎4.5 Other Topics‎ > ‎

4.54 Upload outstanding and paid invoices

Invoice upload is used to upload or your past invoiced both outstanding or paid. 

  1. Navigate to Customer >> Upload Multiple Customers
  2. Scroll down and click on Download Template for Invoice

Figure 1.0 shows the download template button

    3. Fill in all the relevant details in the template. Below are the specifications and definitions of the fields in the template

NoFieldRequiredNotes
1Invoice NumberYAutomatically Generated or User driven
2Customer IdNThe BluSynergy assigned customer id. Either this field or the CustomerAccountNumber must be specified to identify the customer that owns this order
3Customer RefYThe externally assigned customer reference number. Either this field or the CustomerId must be specified to identify the customer that owns this order
4Invoice DateYThe date when Invoice was generated
5Due DateYThe date when the invoice is due for payment
6StatusYStatus of the invoice (Paid or Outstanding)
7Previous BalanceNIf there was any previous balance can be mentioned. This number needs to accurate
8Current Amount DueNThis is the current amount due to be paid by your customer if any
9Payments And AdjustmentsNThis is when any adjustment is done like credits or debits
10Billing StartDateYThis is subscription start date
11Billing EndDateYThis is the subscription end date
12NoteNCan mention some notes for your reference
13SubscriptionOrderId1NThis is auto generated ID from the system for every Order
14ContractCode1YThe ContractCode corresponding to the Plan.
15Position1YThis corresponds to the first line item in your invoice
16PriceCode1YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
17Invoice Text1NThis is the text that needs to appear on the invoice
18Accounting Code1NAccounting code from an external system can be mentioned here if any
19Unit Price1YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
20Quantity1YThe quantity must be specified
21Amount1NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
22SubscriptionOrderId2NThis is auto generated ID from the system for every Order
23ContractCode2YThe ContractCode corresponding to the Plan.
24Position2YThis corresponds to the first line item in your invoice
25PriceCode2YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
26Invoice Text2NThis is the text that needs to appear on the invoice
27Accounting Code2NAccounting code from an external system can be mentioned here if any
28Unit Price2YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
29Quantity2YThe quantity must be specified
30Amount2NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
31SubscriptionOrderId3NThis is auto generated ID from the system for every Order
32ContractCode3YThe ContractCode corresponding to the Plan.
33Position3YThis corresponds to the first line item in your invoice
34PriceCode3YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
35Invoice Text3NThis is the text that needs to appear on the invoice
36Accounting Code3NAccounting code from an external system can be mentioned here if any
37Unit Price3YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
38Quantity3YThe quantity must be specified
39Amount3NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
40SubscriptionOrderId4NThis is auto generated ID from the system for every Order
41ContractCode4YThe ContractCode corresponding to the Plan.
42Position4YThis corresponds to the first line item in your invoice
43PriceCode4YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
44Invoice Text4NThis is the text that needs to appear on the invoice
45Accounting Code4NAccounting code from an external system can be mentioned here if any
46Unit Price4YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
47Quantity4YThe quantity must be specified
48Amount4NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
49SubscriptionOrderId5NThis is auto generated ID from the system for every Order
50ContractCode5YThe ContractCode corresponding to the Plan.
51Position5YThis corresponds to the first line item in your invoice
52PriceCode5YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
53Invoice Text5NThis is the text that needs to appear on the invoice
54Accounting Code5NAccounting code from an external system can be mentioned here if any
55Unit Price5YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
56Quantity5YThe quantity must be specified
57Amount5NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
58SubscriptionOrderId6NThis is auto generated ID from the system for every Order
59ContractCode6YThe ContractCode corresponding to the Plan.
60Position6YThis corresponds to the first line item in your invoice
61PriceCode6YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
62Invoice Text6NThis is the text that needs to appear on the invoice
63Accounting Code6NAccounting code from an external system can be mentioned here if any
64Unit Price6YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
65Quantity6YThe quantity must be specified
66Amount6NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
67SubscriptionOrderId7NThis is auto generated ID from the system for every Order
68ContractCode7YThe ContractCode corresponding to the Plan.
69Position7YThis corresponds to the first line item in your invoice
70PriceCode7YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
71Invoice Text7NThis is the text that needs to appear on the invoice
72Accounting Code7NAccounting code from an external system can be mentioned here if any
73Unit Price7YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
74Quantity7YThe quantity must be specified
75Amount7NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
76SubscriptionOrderId8NThis is auto generated ID from the system for every Order
77ContractCode8YThe ContractCode corresponding to the Plan.
78Position8YThis corresponds to the first line item in your invoice
79PriceCode8YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
80Invoice Text8NThis is the text that needs to appear on the invoice
81Accounting Code8NAccounting code from an external system can be mentioned here if any
82Unit Price8YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
83Quantity8YThe quantity must be specified
84Amount8NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
85SubscriptionOrderId9NThis is auto generated ID from the system for every Order
86ContractCode9YThe ContractCode corresponding to the Plan.
87Position9YThis corresponds to the first line item in your invoice
88PriceCode9YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
89Invoice Text9NThis is the text that needs to appear on the invoice
90Accounting Code9NAccounting code from an external system can be mentioned here if any
91Unit Price9YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
92Quantity9YThe quantity must be specified
93Amount9NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
94SubscriptionOrderId10NThis is auto generated ID from the system for every Order
95ContractCode10YThe ContractCode corresponding to the Plan.
96Position10YThis corresponds to the first line item in your invoice
97PriceCode10YThe PriceCode corresponding to the Charge for the Plan. This PriceCode must obviously be one of the charges under the Plan identified by the 'ContractCode' field
98Invoice Text10NThis is the text that needs to appear on the invoice
99Accounting Code10NAccounting code from an external system can be mentioned here if any
100Unit Price10YThe rated unit price for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
101Quantity10YThe quantity must be specified
102Amount10NThe rated amount for the invoice record. This is assigned only after the activity has been "processed" (as indicated by the status column)
103Order NumberYThis is Order number of your orders generated for the invoices

    4. Locate your file and upload the same
Comments