JP7525466B2 - Import overhead management device, import overhead management method, and import overhead management program - Google Patents

Description

The present invention relates to an import overhead management device, an import overhead management method, and an import overhead management program.

Patent Document 1 discloses a configuration in which the customs duty amount is managed by contract concluded for each import, the purchase amount of goods is managed by goods and contract, and an apportionment process is performed for multiple purchases, thereby managing the customs duty amount levied for each product by invoice.

JP 2021-144690 A

However, the invention described in the above-mentioned Patent Document 1 had a problem in that, when recording liquor tax, it was not possible to apportion the cost price from the recorded expenses only to those products that fall under the category of alcoholic beverages among the mixed products.

The present invention was made in consideration of the above problems, and aims to provide an import overhead management device, an import overhead management method, and an import overhead management program that enable selection of the target invoice for overhead input, and that, when the expense being recorded is an item that corresponds to liquor tax, links the product to be apportioned and allows allocation only to the target product.

In order to solve the above-mentioned problems and achieve the object, the import overhead management device of the present invention is an import overhead management device equipped with a memory unit and a control unit, the memory unit is equipped with an item master in which liquor tax items are set, and a product master in which products, liquor tax items, and liquor tax coefficients are linked and set, and the control unit is equipped with an arrival acquisition means for acquiring arrival data on an invoice basis in which the arrival quantity of the product of the import transaction mixed in a transport vehicle is set, an arrival overhead selection display means for displaying an arrival overhead selection screen that allows the arrival data to be selected as the target for the arrival overhead, an arrival overhead input display means for displaying an arrival overhead input screen in which the expense amount can be set when selected arrival data is selected from the arrival data on the arrival overhead selection screen, and an allocation acquisition means for acquiring the overhead apportionment amount apportioned for each selected arrival data based on the expense master and the product master when the expense amount is set on the arrival overhead input screen.

In addition, in the import expenses management device according to the present invention, the apportionment acquisition means, when the expense amount is set on the purchase expenses input screen, calculates the apportionment amount standard amount by multiplying the arrival quantity of each selected arrival data by the liquor tax coefficient based on the expense item master and the product master, and acquires the quotient obtained by multiplying the expense amount by the apportionment amount standard amount of each selected arrival data as the dividend and the sum of the apportionment amount standard amounts of all the selected arrival data as the divisor as the apportionment amount of the expenses.

In addition, in the import overhead management device according to the present invention, the incoming data further includes a purchase amount for each invoice, and the control unit further includes an allocation detail acquisition means for acquiring the purchase amount for the commodity and overhead allocation detail data in which the overhead allocation amount is set.

In addition, in the import overhead management device according to the present invention, the control unit is characterized by further comprising an apportionment input display means for displaying an apportionment input screen that allows the apportionment amount of the overhead for each selected incoming data to be changed, and an apportionment update means for updating the selected incoming data based on the changed amount when the apportionment amount of the overhead is changed on the apportionment input screen.

In addition, in the import overhead management device according to the present invention, the apportionment acquisition means is further characterized in that it acquires overhead detail data in which the expense amount is set as the overhead amount.

In addition, in the import charges management device according to the present invention, the purchase charges selection and display means is characterized by displaying the purchase charges selection screen that allows the arrival data to be recorded as the purchase charges to be selected by specifying the arrival number, supplier code, expected arrival number, or range of booking numbers.

In addition, in the import overhead management device of the present invention, the arrival acquisition means acquires the arrival schedule data for each invoice, which is set by linking the expected arrival number, order number, supplier, the product, the expected arrival quantity, invoice number, and a booking number assigned to each of the means of transport carrying the product, and acquires the arrival data for each invoice, which is set by linking the arrival number, the expected arrival number, the order number, the supplier, the product, the expected arrival quantity, the invoice number, and the booking number, based on the arrival schedule data.

In addition, in the import overhead management device according to the present invention, the control unit further includes an order acquisition means for acquiring order data that is set by linking the order number, the supplier, the product, and the order quantity, and the arrival acquisition means acquires the scheduled arrival data for each invoice based on the order data, and acquires the arrival data for each invoice based on the scheduled arrival data.

In addition, in the import expense management device according to the present invention, the means of transportation is a ship or an airplane.

The import overhead management method according to the present invention is an import overhead management method to be executed by an import overhead management device having a memory unit and a control unit, the memory unit having an item master in which liquor tax items are set, and a product master in which products, liquor tax items, and liquor tax coefficients are linked, and the control unit is characterized by including an arrival acquisition step to acquire arrival data for each invoice in which the arrival quantity of the product of the import transaction consolidated in a transport vehicle is set, an arrival overhead selection display step to display an arrival overhead selection screen that allows the arrival data to be selected as the target for the arrival overhead, an arrival overhead input display step to display an arrival overhead input screen that allows the expense amount to be set when selected arrival data is selected from the arrival data on the arrival overhead selection screen, and an apportionment acquisition step to acquire the apportionment amount apportioned for each selected arrival data based on the expense master and the product master when the expense amount is set on the arrival overhead input screen.

The import overhead management program according to the present invention is an import overhead management program to be executed by an import overhead management device having a memory unit and a control unit, the memory unit having an item master in which liquor tax items are set, and a product master in which products, liquor tax items, and liquor tax coefficients are linked together, and the control unit executes an arrival acquisition step of acquiring arrival data on an invoice basis in which the arrival quantity of the product of the import transaction mixed in a transport vehicle is set, an arrival overhead selection display step of displaying an arrival overhead selection screen that allows the arrival data to be selected as the target of the purchase overhead, an arrival overhead input display step of displaying an arrival overhead input screen that allows the expense amount to be set when selected arrival data is selected from the arrival data on the arrival overhead selection screen, and an apportionment acquisition step of acquiring the apportionment amount apportioned for each selected arrival data based on the expense master and the product master when the expense amount is set on the purchase overhead input screen.

The present invention has the effect of realizing the calculation of charges for the entire ship when goods imported under multiple invoice transactions are mixed on one ship. The present invention also has the effect of improving the efficiency of work when calculating liquor tax and reducing the risk of operational errors. The present invention also has the effect of enabling companies that handle alcoholic beverages to accurately grasp liquor tax (expenses). The present invention also has the effect of identifying the arrival details that are subject to liquor tax and are combined into one mixed bottle, and allocating liquor tax to the target arrival details. The present invention also has the effect of initially displaying a screen showing the results of the allocation of charges. The present invention also has the effect of allowing multiple scheduled arrival numbers or arrival numbers to be selected when selecting the target invoice for inputting charges.

FIG. 1 is a block diagram showing an example of the configuration of an import expenses management device according to this embodiment. FIG. 2 is a diagram showing an example of the expense item master in this embodiment. FIG. 3 is a diagram showing an example of the classification master in this embodiment. FIG. 4 is a diagram showing an example of the product master in this embodiment. FIG. 5 is a diagram showing an example of the supplier master data in this embodiment. FIG. 6 is a flowchart showing an example of the process of the import expenses management device in this embodiment. FIG. 7 is a diagram showing an example of import charges management processing in this embodiment. FIG. 8 is a diagram showing an example of import charge management processing in this embodiment. FIG. 9 is a diagram showing an example of import charge management processing in this embodiment. FIG. 10 is a diagram showing an example of import charge management processing in this embodiment. FIG. 11 is a diagram showing an example of import charge management processing in this embodiment. FIG. 12 is a diagram showing an example of import charges management processing in this embodiment. FIG. 13 is a diagram showing an example of import charges management processing in this embodiment.

The embodiment of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to this embodiment.

[1. Overview]
First, an overview of the present invention will be described.

Traditionally, when recording miscellaneous expenses in import transactions, it has been common to record miscellaneous expenses for each invoice (an invoice that requires the applicable tax rate and tax amount to be stated). However, when products imported under multiple invoice transactions are mixed onto a single ship, expenses must be recorded in a combined form for the multiple mixed invoices, and miscellaneous expenses must be recorded for each invoice. As a result, it was necessary to manually calculate the amount of each invoice for the total expenses, and then record the miscellaneous expenses. Additionally, traditionally, when recording liquor tax as miscellaneous expenses, each person in charge had to select the products that were subject to liquor tax and record them proportionately.

Therefore, in this embodiment, in order to meet the requirement of a system that allows expenses to be recorded in a consolidated manner for multiple invoices in a manner that is in line with actual transactions, and the requirement of being able to allocate the cost price for liquor tax only to the products to which it applies, a system is provided that can meet each requirement when entering miscellaneous expenses.

In other words, in this embodiment, when selecting the invoice to be used for inputting miscellaneous expenses, it is possible to select multiple scheduled arrival numbers or arrival numbers, and if the expense to be recorded is an item that corresponds to liquor tax, the products to be allocated are linked in the master settings, and only the applicable products can be allocated, and when allocating, a coefficient is set for each product code, and allocation is performed in the ratio of "number of arrivals x coefficient".

2. Configuration
An example of the configuration of the import expenses management device 100 according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of the import expenses management device 100 according to this embodiment.

As shown in FIG. 1, the import expense management device 100 is a commercially available desktop personal computer. Note that the import expense management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The import expense management device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit of the import expense management device 100 is connected to each other so that they can communicate with each other via any communication path.

The communication interface unit 104 communicatively connects the import expense management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the import expense management device 100 and the server 200 to each other so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

An input device 112 and an output device 114 are connected to the input/output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to provide a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes an expense item master 106a, a category master 106b, a product master 106c, a supplier master 106d, and a transaction database 106e.

The item master 106a is a master that sets the liquor tax items. Here, the item master 106a may also have the item identifier and liquor tax category set.

Here, an example of the expense item master 106a in this embodiment will be described with reference to FIG. 2. FIG. 2 is a diagram showing an example of the expense item master 106a in this embodiment.

As shown in FIG. 2, in the item master 106a in this embodiment, the item code (CD), item name, and liquor tax category are linked and set.

Returning to Figure 1, category master 106b is the master that sets the liquor tax category.

Here, an example of the division master 106b in this embodiment will be described with reference to FIG. 3. FIG. 3 is a diagram showing an example of the division master 106b in this embodiment.

As shown in FIG. 3, in the category master 106b in this embodiment, the liquor tax category and the category contents are linked and set. Here, as shown in FIG. 3, in this embodiment, if the liquor tax category is 1, it may be subject to apportionment.

Returning to Figure 1, product master 106c is a master that links and sets products, liquor tax items, and liquor tax coefficients.

Here, an example of the product master 106c in this embodiment will be described with reference to FIG. 4. FIG. 4 is a diagram showing an example of the product master 106c in this embodiment.

As shown in FIG. 4, in the product master 106c in this embodiment, the product code, product name, liquor tax item code, and liquor tax coefficient are linked and set.

Returning to Figure 1, the customer master 106d is a master that links and sets customer and roles.

Here, an example of the supplier master 106d in this embodiment will be described with reference to FIG. 5. FIG. 5 is a diagram showing an example of the supplier master 106d in this embodiment.

As shown in FIG. 5, in the customer master 106d of this embodiment, the customer code, customer name, and role are linked and set.

Returning to FIG. 1, the transaction database 106e stores transaction data. Here, the transaction data may include order data, arrival schedule data, arrival data, selected arrival data, charge allocation details data, and/or charge details data, etc.

The control unit 102 is a CPU or the like that controls the import overhead management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. In terms of function, the control unit 102 includes an order acquisition unit 102a, a receipt acquisition unit 102b, a purchase overhead selection display unit 102c, a purchase overhead input display unit 102d, an allocation acquisition unit 102e, an allocation input display unit 102f, an overhead allocation update unit 102g, and an allocation details acquisition unit 102h.

The order acquisition unit 102a acquires order data that sets the product of the import transaction. Here, the order acquisition unit 102a may acquire order data that sets the order number, supplier, product, and order quantity of the import transaction in association with each other.

The arrival acquisition unit 102b acquires arrival data of goods in an import transaction. Here, the arrival acquisition unit 102b may acquire arrival data on an invoice basis, which sets the arrival quantity of the goods in an import transaction that are mixed in a transport vehicle. The arrival data may also be set as the purchase amount on an invoice basis. The arrival acquisition unit 102b may acquire arrival schedule data on an invoice basis, which is set by linking the arrival schedule number, order number, supplier, goods, expected arrival quantity, invoice number, and booking number assigned to each transport vehicle that carries the goods, and may acquire arrival data on an invoice basis, which is set by linking the arrival number, expected arrival number, order number, supplier, goods, expected arrival quantity, invoice number, and booking number based on the arrival schedule data. The arrival acquisition unit 102b may also acquire arrival schedule data on an invoice basis based on the order data, and acquire arrival data on an invoice basis based on the arrival schedule data. The transport vehicle may also be a ship or an airplane.

The purchase charges selection display unit 102c displays a purchase charges selection screen that allows the selection of incoming data to be included in the purchase charges. Here, the purchase charges selection display unit 102c may display a purchase charges selection screen that allows the selection of incoming data to be included in the purchase charges by specifying the incoming data number, the supplier code, the expected incoming data number, or the range of the booking number.

The purchase charges input display unit 102d displays a purchase charges input screen that allows the expense amount to be set. Here, when selected incoming data is selected from incoming data on the purchase charges selection screen, the purchase charges input display unit 102d may display a purchase charges input screen that allows the expense amount to be set.

The allocation acquisition unit 102e acquires the miscellaneous charges apportioned amount for each selected arrival data based on the expense item master 106a and the product master 106c. Here, when the expense amount is set on the purchase miscellaneous charges input screen, the allocation acquisition unit 102e may acquire the miscellaneous charges apportioned amount for each selected arrival data based on the expense item master 106a and the product master 106c. In addition, when the expense amount is set on the purchase miscellaneous charges input screen, the allocation acquisition unit 102e may calculate the apportionment amount standard amount by multiplying the arrival quantity and the liquor tax coefficient of each selected arrival data based on the expense item master 106a and the product master 106c, and may acquire the quotient when the sum of the apportionment amount standard amount of all the selected arrival data is used as the divisor as the miscellaneous charges apportionment amount. The apportionment acquisition unit 102e may also acquire miscellaneous expenses detail data in which the expense amount is set as the miscellaneous expenses amount.

The apportionment input display unit 102f displays an apportionment input screen that allows the user to change the apportionment amount for each selected incoming data.

When the miscellaneous charges apportionment amount is changed on the apportionment input screen, the miscellaneous charges apportionment update unit 102g updates the selected arrival data based on the changed amount.

The apportionment details acquisition unit 102h acquires the purchase price of the product and the miscellaneous charges apportionment details data that sets the apportionment amount of the miscellaneous charges.

3. Specific Examples
A specific example of this embodiment will be described with reference to FIGS.

[Import charges management processing]
An example of import expense management processing in this embodiment will now be described with reference to Fig. 6. Fig. 6 is a flow chart showing an example of processing by the import expense management device 100 in this embodiment.

As shown in FIG. 6, when a user inputs an order via the input device 112, the order acquisition unit 102a acquires order data that links together the order number, order detail line number, expected arrival date, supplier, product, and order quantity for the import transaction that is consolidated into the transport vehicle (step SA-1).

When the user inputs the expected arrival information via the input device 112, the arrival acquisition unit 102b acquires the expected arrival data on an invoice basis based on the order data, which is linked to the expected arrival number, expected arrival line number, order number, order line number, expected arrival date, supplier, product, expected arrival quantity, invoice number, and the booking number assigned to each transportation means that will carry the product (step SA-2).

Then, when the user inputs arrival information via the input device 112, the arrival acquisition unit 102b acquires arrival data on an invoice basis, which is set by linking the arrival number, arrival detail line number, scheduled arrival number, scheduled arrival detail line number, order number, order detail line number, arrival date, supplier, product, arrival quantity, and booking number based on the scheduled arrival data (step SA-3).

Then, the purchase charges selection display unit 102c displays a purchase charges selection screen on the output device 114, which allows the purchase data to be recorded as purchase charges to be selected by specifying the range of the arrival number, supplier code, expected arrival number, or booking number (step SA-4).

Then, when the user selects selected receipt data from receipt data on the purchase charges selection screen via the input device 112, the purchase charges input display unit 102d causes the output device 114 to display a purchase charges input screen that allows the user to set the expense item, accounting date, business partner, and expense amount (step SA-5).

Then, when the expense amount is set by the user on the purchase charges input screen via the input device 112, the apportionment acquisition unit 102e calculates the apportionment amount standard amount by multiplying the arrival quantity of each selected arrival data by the liquor tax coefficient based on the expense item master 106a and the product master 106c, and obtains the quotient when the expense amount is multiplied by the apportionment amount standard amount of each selected arrival data as the dividend and the sum of the apportionment amount standard amounts of all the selected arrival data as the divisor as the apportionment amount of the expenses (step SA-6).

Then, the apportionment input display unit 102f displays an apportionment input screen that allows the user to change the apportionment amount for each selected incoming data (step SA-7).

Then, the miscellaneous charges allocation update unit 102g determines whether the miscellaneous charges allocation amount has been changed by the user on the allocation input screen via the input device 112 (step SA-8).

Then, if the charges apportionment update unit 102g determines that the charges apportionment amount has not been changed (step SA-8: No), it transitions the process to step SA-10.

On the other hand, if the charges apportionment update unit 102g determines that the charges apportionment amount has been changed (step SA-8: Yes), it transitions the process to step SA-9.

Then, the charges apportionment update unit 102g updates the selected receipt data based on the changed charges apportionment amount on the apportionment input screen (step SA-9), and transitions the process to step SA-10.

Then, the apportionment details acquisition unit 102h acquires the miscellaneous charges apportionment details data, which includes the import miscellaneous charges number, miscellaneous charges apportionment detail line number, apportionment line number, apportionment check indicating whether or not apportionment has been applied, expense code, product code, arrival number, arrival detail line number, scheduled arrival number, scheduled arrival detail line number, liquor tax coefficient, product purchase price, and miscellaneous charges apportionment amount (step SA-10), and ends the process.

Here, an example of import overhead management processing in this embodiment will be described with reference to Figures 7 to 13. Figures 7 to 13 are diagrams showing an example of import overhead management processing in this embodiment.

In this embodiment, as shown in FIG. 7, order data is registered by order input by the user, as shown in FIG. 8, arrival schedule data is registered on an invoice basis by the user's arrival schedule input, and as shown in FIG. 9, arrival data for arrival numbers 21CJ00000001 and 21CJ00000002 received from the same ship is registered on an invoice basis by the user's arrival input.

In this embodiment, as shown in FIG. 10, the user selects the target invoice on the purchase charges selection screen, which has selection buttons implemented so that multiple receipt numbers to be recorded can be selected.

In this embodiment, as shown in FIG. 11, when the user inputs the liquor tax amount on the purchase charges input screen and then presses the "Apportionment Input" button, the liquor tax category set in the expense item master 106a is referenced from the input liquor tax amount, as shown in FIG. 12, and the amount is allocated to only the relevant products and initially displayed on the apportionment input screen. Here, since the apportionment amount is initially displayed on the apportionment input screen in this embodiment, it can be edited and adjusted, and if a fraction occurs during the initial allocation, it can be added to the details in the first row.

In this embodiment, as shown in FIG. 13, miscellaneous charge detail data in which the expense amount is set as the miscellaneous charge amount is obtained to update the expense item detail line, and miscellaneous charge allocation detail data in which the product purchase amount and the miscellaneous charge allocation amount are set is obtained to update the allocation result.

In this embodiment, a liquor tax category is provided in the expense master 106a, making it possible to determine whether or not an item is subject to liquor tax. In addition, in this embodiment, a liquor tax item item is provided in the product master 106c, making it possible to automatically determine whether or not an item code set in the expense master 106a is subject to allocation when the item code is recorded. In addition, in this embodiment, a liquor tax item code item is added to the product master 106c, and which items are subject to allocation among the items set in the expense master 106a as liquor tax category: "1" are registered. In addition, in this embodiment, a liquor tax coefficient is set for each product code 106c, and is used as the allocation standard. In addition, in this embodiment, a check box for whether or not the item is subject to allocation is added to the import miscellaneous charges allocation input screen, and when liquor tax linkage is set, only the target product details are initially displayed with the allocation check (note that it is possible to change the check on the screen). Also, in this embodiment, for items that are not subject to liquor tax, all product details may initially be displayed on the allocation input screen with a check mark indicating that they are subject to allocation.

[4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)]
This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

5. Other embodiments
The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using a known method.

In addition, the processing procedures, control procedures, specific names, registered data for each process, information including search conditions and other parameters, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

In addition, with regard to the import expenses management device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the import expense management device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the import expense management device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the import expense management device 100 via any network, and it may be possible to download all or part of it as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, or may be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile This includes any "portable physical media" such as a Blu-ray (registered trademark) Disc, and a Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit 106 are storage devices such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

The import expense management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The import expense management device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

This invention is useful in the import industry in general.

100 Import charges management device 102 Control unit 102a Order acquisition unit 102b Arrival acquisition unit 102c Purchase charges selection display unit 102d Purchase charges input display unit 102e Allocation acquisition unit 102f Allocation input display unit 102g Charge allocation update unit 102h Allocation details acquisition unit 104 Communication interface unit 106 Storage unit 106a Expense item master 106b Classification master 106c Product master 106d Customer master 106e Transaction database 108 Input/output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims (11)

An import expenses management device having a memory unit and a control unit,
The storage unit is
Expense item master with liquor tax items set,
A product master that links products, liquor tax items, and liquor tax coefficients,
Equipped with
The control unit is
An arrival acquisition means for acquiring arrival data for each invoice, the arrival data including the arrival quantity of the commodity of the import transaction consolidated into a transportation facility;
a purchase charge selection display means for displaying a purchase charge selection screen that allows the receipt data to be selected as a target for recording the purchase charge;
a purchase expenses input display means for displaying a purchase expenses input screen on which an expense amount can be set when selected receipt data is selected from the receipt data on the purchase expenses selection screen;
an apportionment acquisition means for acquiring the apportioned amount of the expenses for each of the selected receipt data based on the expense item master and the product master when the expense amount is set on the purchase expense input screen;
An import expenses management device comprising: The apportionment acquisition means is
The import expenses management device of claim 1, characterized in that when the expense amount is set on the purchase expenses input screen, an apportionment amount standard amount is calculated by multiplying the arrival quantity of each selected arrival data by the liquor tax coefficient based on the expense item master and the product master, and the quotient obtained by multiplying the expense amount by the apportionment amount standard amount of each selected arrival data is used as the dividend and the sum of the apportionment amount standard amounts of all the selected arrival data is used as the divisor is obtained as the apportionment amount of expenses. The arrival data is
Furthermore, the purchase amount of the invoice unit is set,
The control unit is
an apportionment detail acquisition means for acquiring the purchase price of the commodity and the apportionment detail data in which the apportionment amount of the various charges is set;
3. The import expenses management device according to claim 1, further comprising: The control unit is
an apportionment input display means for displaying an apportionment input screen that allows the apportionment amount of the charges for each selected receipt data to be changed;
an apportionment update means for updating the selected receipt data based on the changed amount when the apportionment amount is changed on the apportionment input screen;
4. The import expenses management device according to claim 1, further comprising: The apportionment acquisition means is
5. The import expenses management device according to claim 1, further comprising: an expenses detail data setting the expense amount as the expenses amount. The purchasing expenses selection and display means is
The import expenses management device according to any one of claims 1 to 5, characterized in that the purchase expenses selection screen is displayed, which allows the import data to be recorded as the purchase expenses to be selected by specifying a range of import numbers, supplier codes, scheduled import numbers, or booking numbers. The arrival acquisition means includes:
An import expense management device as described in any one of claims 1 to 6, characterized in that it acquires scheduled arrival data for each invoice, which is set by linking the scheduled arrival number, order number, supplier, the product, the scheduled arrival quantity, invoice number, and a booking number assigned to each of the transportation means carrying the product, and acquires the arrival data for each invoice, which is set by linking the arrival number, the scheduled arrival number, the order number, the supplier, the product, the scheduled arrival quantity, the invoice number, and the booking number, based on the scheduled arrival data. The control unit is
an order acquisition means for acquiring order data that is set by linking the order number, the supplier, the product, and the order quantity;
Further comprising:
The arrival acquisition means includes:
8. The import expenses management device according to claim 7, characterized in that the arrival schedule data for each invoice is obtained based on the order data, and the arrival data for each invoice is obtained based on the arrival schedule data. The transportation means includes:
9. The import expenses management device according to claim 1, wherein the import expenses management device is a ship or an airplane. An import expenses management method to be executed by an import expenses management device having a storage unit and a control unit,
The storage unit is
Expense item master with liquor tax items set,
A product master that links products, liquor tax items, and liquor tax coefficients,
Equipped with
The control unit executes
An arrival acquisition step of acquiring arrival data for each invoice, the arrival data including the arrival quantity of the commodity of the import transaction consolidated into a transportation facility;
a purchase charge selection display step of displaying a purchase charge selection screen that allows the receipt data to be selected as a target for recording the purchase charge;
a purchase expenses input display step of displaying a purchase expenses input screen that allows an expense amount to be set when selected receipt data is selected from the receipt data on the purchase expenses selection screen;
When the expense amount is set on the purchase expense input screen, an allocation acquisition step of acquiring the expense allocation amount allocated for each of the selected receipt data based on the expense item master and the product master;
A method for managing import expenses, comprising: An import expense management program to be executed by an import expense management device having a storage unit and a control unit,
The storage unit is
Expense item master with liquor tax items set,
A product master that links products, liquor tax items, and liquor tax coefficients,
Equipped with
In the control unit,
An arrival acquisition step of acquiring arrival data for each invoice, the arrival data including the arrival quantity of the commodity of the import transaction consolidated into a transportation facility;
a purchase charge selection display step of displaying a purchase charge selection screen that allows the receipt data to be selected as a target for recording the purchase charge;
a purchase expenses input display step of displaying a purchase expenses input screen that allows an expense amount to be set when selected receipt data is selected from the receipt data on the purchase expenses selection screen;
an allocation acquisition step of acquiring the prorated amount of expenses for each of the selected receipt data based on the expense item master and the product master when the expense amount is set on the purchase expense input screen;
Import charges management program to implement the above.

Images