CN111127122A - Order splitting and merging algorithm of invoice management system - Google Patents
Order splitting and merging algorithm of invoice management system Download PDFInfo
- Publication number
- CN111127122A CN111127122A CN201811277672.1A CN201811277672A CN111127122A CN 111127122 A CN111127122 A CN 111127122A CN 201811277672 A CN201811277672 A CN 201811277672A CN 111127122 A CN111127122 A CN 111127122A
- Authority
- CN
- China
- Prior art keywords
- invoice
- order
- splitting
- invoicing
- orders
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 claims abstract description 11
- 238000007596 consolidation process Methods 0.000 claims 1
- 238000000926 separation method Methods 0.000 claims 1
- 238000011160 research Methods 0.000 abstract description 2
- 238000004364 calculation method Methods 0.000 description 8
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/04—Billing or invoicing
Landscapes
- Business, Economics & Management (AREA)
- Development Economics (AREA)
- Accounting & Taxation (AREA)
- Economics (AREA)
- Finance (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invoicing is an important link for realizing the use value of the invoice and reflecting economic business activities, and whether the invoicing is real, complete and correct directly relates to whether the expected purpose of invoice management can be achieved. However, the current billing process for most businesses is not as convenient for customers. For example, a customer completes a multiple transaction in one day, and the customer needs to make an order one by one; when the single reimbursement amount exceeds a certain value, an enterprise needs to go through a complex flow; when making special tickets, when some commodities can not make special tickets, etc. In order to deal with the pain points, the aviation credit profit deeply researches the invoice issuing process, and a splitting and merging algorithm for orders is invented.
Description
Technical Field
The system provides an order splitting and merging algorithm, particularly relates to a technology for issuing invoices after order splitting and merging by an invoice system, and belongs to the field of data structures and algorithms.
Background
The invoicing is an important link for realizing the use value of the invoice and reflecting economic business activities, and whether the invoicing is real, complete and correct directly relates to whether the expected purpose of invoice management can be achieved. However, the current billing process for most businesses is not as convenient for customers. For example, a customer completes a multiple transaction in one day, and the customer needs to make an order one by one; when the single reimbursement amount exceeds a certain value, an enterprise needs to go through a complex flow; when making special tickets, when some commodities can not make special tickets, etc. In order to deal with the pain points, the aviation credit profit deeply researches the invoice issuing process, and a splitting and merging algorithm for orders is invented.
Disclosure of Invention
The method comprises an order splitting and merging splitting billing calculation strategy.
Firstly, an order splitting invoicing calculation strategy:
the strategy emphasizes the experience of the customer in the whole invoice issuing process, helps the customer to freely select the invoicing quantity and the invoicing amount when issuing an invoice for a certain order, fully considers the convenience of issuing the invoice, and is easy to operate and intelligent.
1) Automatically splitting billing modes according to quota:
(1) assume that the total amount of invoices for an order is AM.
(2) Assume that the user input quota is LM.
(3) Assume that the order has items I1, I2, I3, corresponding to unit prices P1, P2, P3, and corresponding quantities Q1, Q2, Q3.
The system automatically invoices according to the limit, the number of the invoices is n = ⌈ AM/LM ⌉, if P1Q 1< LM, but (P1Q 1+ P2Q 2) > LM, the first invoice split is detailed as:
unit price of item quantity
I1 Q1 P1
I2 ((P2*Q2-((P1*Q1+P2*Q2)-LM))÷(P2*Q2))*Q2 P2
If the item I2 (P1Q 1+ P2Q 2) -LM) + item I3 (P3Q 3) > LM remains after the first invoice is broken, the second broken invoice is detailed as:
unit price of item quantity
I2 Q2-((P2*Q2-((P1*Q1+P2*Q2)-LM))÷(P2*Q2))*Q2 P2
I3 ((P3*Q3-((AT2+P3*Q3)-LM))÷(P3*Q3))*Q3 P3
Note: the remaining I2 amount AT2= ((P1Q 1+ P2Q 2) -LM)
If the remaining I3 amount is < LM, the split third invoice detail is:
unit price of item quantity
I3 Q3-((P3*Q3-((AT2+P3*Q3)-LM))÷(P3*Q3))*Q3 P3
Single order quota automatic splitting strategy see FIG. 1
2) Manually splitting according to the percentage of the number of items:
(1) assume that the order has items I1, I2, I3, corresponding to unit prices P1, P2, P3, corresponding to quantities Q1, Q2, Q3.
(2) Assume that the user requires an average of three invoices per amount of the order.
(3) Assuming that the amount of each invoice does not exceed the limit, the system will prompt and ask for a new percentage to be entered if the limit is exceeded.
Only manual splitting is selected, 33.33% of input orders are used for issuing one invoice, 50% of input orders are used for issuing the second invoice, and the rest orders are used for issuing the third invoice. The system will calculate the number of commodities automatically according to the percentage, and the first invoice detail calculated is:
unit price of item quantity
I1 Q1*0.3333 P1
I2 Q2*0.3333 P2
I3 Q3*0.3333 P3
The second invoice detail is:
unit price of item quantity
I1 (Q1-Q1*0.3333)*0.5 P1
I2 (Q2-Q2*0.3333)*0.5 P2
I3 (Q3-Q3*0.3333)*0.5 P3
The third invoice detail is:
unit price of item quantity
I1 Q1-(Q1*0.3333+(Q1-Q1*0.3333)*0.5) P1
I2 Q2-(Q2*0.3333+(Q2-Q2*0.3333)*0.5) P2
I3 Q3-(Q3*0.3333+(Q3-Q3*0.3333)*0.5) P3
Order splitting by percentage strategy see figure 2
3) Splitting manually according to the number of items:
(1) assume that the order has items I1, I2, I3, corresponding to unit prices P1, P2, P3, corresponding to quantities Q1, Q2, Q3.
(2) Assume that the user asks item I1 and half of item I2 to invoice, and the other half of item I2 and item I3 to invoice
(3) Assuming that the amount of each invoice does not exceed the limit, the system will prompt and ask for a re-selection and entry of the amount if the limit is exceeded.
Only the manual split needs to be selected, the items I1 and I2 are selected, and the number of I2 is modified to Q2 ÷ 2 to produce one invoice, and the remaining items I2 and I3 are selected to produce a second invoice. The system will invoice according to the number input by the user, the first invoice detail is:
unit price of item quantity
I1 Q1 P1
I2 Q2*0.5 P2
The second invoice detail is:
unit price of item quantity
I2 Q2-Q2*0.5 P2
I3 Q3 P3
Order split by number strategy see figure 3
Secondly, order merging and splitting billing calculation strategy:
the strategy emphasizes the experience of the customer on the combination of the multiple orders for invoicing, helps the customer to freely select the invoicing quantity and the invoicing amount when the accumulated multiple orders are combined for invoicing one or more invoices, fully considers the convenience when the invoices are invoiced, and is easy to operate and intelligent.
1) Combining multiple orders to issue an invoice:
(1) assume that there are orders with items O1, O2, O3, order O1 with items O1I1, O1I2, O1I3 corresponding to unit prices of O1P1, O1P2, O1P3, corresponding numbers of O1Q1, O1Q2, O1Q3, order O2 with items O2I1, O2I2, O2I3, corresponding unit prices of O2P1, O2P2, O2P3, corresponding numbers of O2Q1, O2Q2, O2Q3, order O3 with items O3I1, O3I2, O3I3, corresponding unit prices of O3P1, O3P2, O3P 3.
(2) Assuming that the amount of consolidated invoices does not exceed the limit, if the amount exceeds the limit, the system will prompt and request that the invoices be split.
Only need select these 3 orders, select all projects and invoice, the invoice detail is:
unit price of item quantity
O1I1 O1Q1 O1P1
O1I2 O1Q2 O1P2
O1I3 O1Q3 O1P3
O2I1 O2Q1 O2P1
O2I2 O2Q2 O2P2
O2I3 O2Q3 O2P3
O3I1 O3Q1 O3P1
O3I2 O3Q2 O3P2
O3I3 O3Q3 O3P3
2) After combining a plurality of orders, automatically splitting and invoicing according to the limit:
because some customers purchase orders and items frequently, and if invoicing is done in a conventional manner, it is quite complicated and labor intensive. The policy is selected to realize automatic invoicing, and manual participation is not needed in the invoicing process.
The orders of a certain client are screened out only according to conditions, the orders are selected and combined to automatically bill according to the limit after being selected completely, the system automatically bills according to the calculation strategy, and the calculation logic is as stated in the first order splitting billing calculation strategy in the mode of 1) automatically splitting billing according to the limit, and the method is not repeated.
Multiple order merge splitting strategy see FIG. 4
Drawings
FIG. 1 illustrates a single order quota based automatic split strategy in accordance with the present invention
FIG. 2 order percentage split strategy in accordance with the present invention
FIG. 3 order quantity split strategy in accordance with the present invention
FIG. 4 illustrates a multi-order merge split strategy according to the present invention
Detailed Description
Firstly, order splitting and invoicing implementation:
required parameters
l GC
Setting the limit of value-added tax general invoice
l SC
Setting limit of special invoice for value-added tax
l TitleInfo
Setting invoice new head related information: head-up, tax number, mailbox, cell phone, bank account, address.
l PER
Split percentage, manual split by percentage is a parameter that is required.
Description of the procedure
1) Step 1: selecting an order
(1) First, the order that needs to be split.
(2) A detailed list of order items is obtained, including items that have been flushed, excluding items that have been billed.
2) Step 2: selection of splitting mode
(1) Firstly, a splitting mode is selected for an order, automatic splitting according to a limit can be selected, manual splitting according to a percentage is selected, and manual splitting according to a quantity is selected.
3) And step 3: counting the number of invoiced items according to a selection policy
(1) The system calculates the number of invoiced items according to the selection policy.
The calculation method is as follows: 1. and calculating the sum of each item of the invoice according to the limit or percentage 2, and dividing the sum by the original sum of the corresponding item to obtain the ratio. 2. And multiplying the obtained ratio by the original quantity of the corresponding items to obtain the split quantity.
Secondly, merging and splitting orders for invoicing:
required parameters
l GC
Setting the limit of value-added tax general invoice
l SC
Setting limit of special invoice for value-added tax
l TitleInfo
Setting invoice new head related information: head-up, tax number, mailbox, cell phone, bank account, address.
l PER
Split percentage, manual split by percentage is a parameter that is required.
Description of the procedure
1) Step 1: selecting consolidated orders
(1) First, the order to be consolidated is selected according to the customer.
(2) And acquiring an item detailed list of all orders, including the items of the bonus, and excluding the items which are already invoiced.
2) Step 2: selection of splitting mode
(1) Firstly, a splitting mode is selected for an order, automatic splitting according to a limit can be selected, splitting according to a percentage is manually selected, and splitting according to a quantity is manually selected
3) And step 3: counting the number of invoiced items according to a selection policy
(1) The system calculates the number of invoiced items according to the selection policy.
The calculation method is as follows: 1. and calculating the sum of each item of the invoice according to the limit or percentage 2, and dividing the sum by the original sum of the corresponding item to obtain the ratio. 2. And multiplying the obtained ratio by the original quantity of the corresponding items to obtain the split quantity.
Claims (3)
1. An algorithm for splitting and merging orders in an invoice management system is characterized in that:
multiple orders may have been combined into one order invoicing, according to the customer's requirements; it is also possible to invoice only a portion of the goods in an order, or to invoice only a portion of the amount in an order.
2. When the amount of the issued invoice exceeds the maximum limit of the enterprise issued invoice, the user can manually split the invoice into a plurality of invoices smaller than the maximum limit as required, and the invoice can also be split according to the maximum limit in a system default mode.
3. The order consolidation and splitting algorithm according to claim 1, wherein: the method ensures that a user can accumulate a plurality of orders, and automatically separates and issues invoices according to the quota at a certain time point regularly, so that the manual participation of the user is avoided as much as possible, and the misoperation and the repeated labor of manual invoicing in the separation process are prevented.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811277672.1A CN111127122A (en) | 2018-10-30 | 2018-10-30 | Order splitting and merging algorithm of invoice management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811277672.1A CN111127122A (en) | 2018-10-30 | 2018-10-30 | Order splitting and merging algorithm of invoice management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111127122A true CN111127122A (en) | 2020-05-08 |
Family
ID=70484618
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811277672.1A Pending CN111127122A (en) | 2018-10-30 | 2018-10-30 | Order splitting and merging algorithm of invoice management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111127122A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105809493A (en) * | 2014-12-30 | 2016-07-27 | 航天信息股份有限公司 | Method and system for processing invoice data |
| CN106204175A (en) * | 2015-05-08 | 2016-12-07 | 航天信息股份有限公司 | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip |
| CN106980994A (en) * | 2016-01-15 | 2017-07-25 | 航天信息股份有限公司 | A kind of method for splitting of billing request document |
| CN107679926A (en) * | 2017-10-11 | 2018-02-09 | 中启行物联科技（北京）有限公司 | A kind of invoice batch intelligence is split and combinational algorithm |
| CN107833081A (en) * | 2017-09-30 | 2018-03-23 | 平安科技（深圳）有限公司 | Automatic method for splitting, device, terminal device and the storage medium of a kind of invoice amount |
-
2018
- 2018-10-30 CN CN201811277672.1A patent/CN111127122A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105809493A (en) * | 2014-12-30 | 2016-07-27 | 航天信息股份有限公司 | Method and system for processing invoice data |
| CN106204175A (en) * | 2015-05-08 | 2016-12-07 | 航天信息股份有限公司 | For opening the method and system of many tax rates VAT invoice without amount of tax to be paid sales slip |
| CN106980994A (en) * | 2016-01-15 | 2017-07-25 | 航天信息股份有限公司 | A kind of method for splitting of billing request document |
| CN107833081A (en) * | 2017-09-30 | 2018-03-23 | 平安科技（深圳）有限公司 | Automatic method for splitting, device, terminal device and the storage medium of a kind of invoice amount |
| CN107679926A (en) * | 2017-10-11 | 2018-02-09 | 中启行物联科技（北京）有限公司 | A kind of invoice batch intelligence is split and combinational algorithm |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6332715B2 (en) | Funding demand service providing system, business server | |
| Chen et al. | Welfare analysis of dynamic pricing | |
| US8156022B2 (en) | Method and system for providing price protection for commodity purchasing through price protection contracts | |
| WO2012097430A1 (en) | System and method for computer-implemented accounting services provided using cloud resources | |
| JP5785272B2 (en) | Unsecured funding system for credit card merchants by purchasing uncertain future credit receivables | |
| CA3155708A1 (en) | Fractional funds transfer/accumulation device, program, and method | |
| US20060167786A1 (en) | System and method for intra-day pricing of mutual funds | |
| WO2001098787A2 (en) | Tariff generation, invoicing and contract management | |
| AU2001267953A1 (en) | Tariff generation, invoicing and contract management | |
| US20140279452A1 (en) | Vendor propensity analysis component for an electronic invoice payment system | |
| JP5491058B2 (en) | Term contract sales management device, term contract sales management method, and term contract sales management program | |
| US20110238540A1 (en) | Financial account management based on specified criteria | |
| KR102247682B1 (en) | System for managemeting Allowance according to Distribution ratio and Driving method thereof | |
| CN105378787A (en) | Shop system | |
| CN111127122A (en) | Order splitting and merging algorithm of invoice management system | |
| CN114037439A (en) | Supply chain system platform collection and payment branch transaction method | |
| CN110633967B (en) | Payment scheme intelligent adjustment system and method | |
| CN101447058A (en) | Contract control device suitable for steel-trading platform and method thereof | |
| CN110580595A (en) | comprehensive office SAAS management platform and management method for connecting multiple systems | |
| KR101839309B1 (en) | Distributed ess management apparatus | |
| CN111242703A (en) | Recharge distribution system | |
| CN110570181A (en) | Intelligent gathering payment system of gas station | |
| CN111179046A (en) | Method and system for realizing automatic payment and posting of sales cost based on invoice data | |
| EP2355029A1 (en) | Electronic clearing and payment system | |
| JP5710037B2 (en) | Information processing apparatus, information processing method, and information processing program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20211027 Address after: 200135 C + d part of mezzanine of building 74, block F24, No. 11, Fute West 2nd Road, China (Shanghai) pilot Free Trade Zone, Pudong New Area, Shanghai Applicant after: Aisino Dudley information systems (Shanghai) Co.,Ltd. Address before: 201103 plant 70, No. 36, Yiwei Road, pilot Free Trade Zone, Pudong New Area, Shanghai Applicant before: YINGLI DUFU INFORMATION SYSTEM (SHANGHAI) CO.,LTD. |
|
| TA01 | Transfer of patent application right | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20200508 |
|
| WD01 | Invention patent application deemed withdrawn after publication |