1 / 50

6. Export Adjustment

6. Export Adjustment. October 1, 2008 Version : 5.0. 1. Export Account Management Overview

lilienthal
Download Presentation

6. Export Adjustment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 6. Export Adjustment October 1, 2008 Version : 5.0

  2. 1. Export Account ManagementOverview If the transport proof is registered and `Confirm` is received from HMI, a sales invoice may be issued. That is, a transport charge may be received from HMI. LOVIS receives the sales charge and pays a purchase charge to a transport vendor. A purchase invoice is issued to pay the purchase charge. Perform a collection entry for inputting a sales amount which is collected from HMI based on the issued sales invoice. Perform a payment entry for inputting a purchase amount which is paid to the transport vendors based on the issued purchase invoice. 2. Export Account ManagementProcess Flow Operator POD Proof of delivery Entry HMI AS400 POD I / F (Interface) Sales Invoice Entry Operator Invoice Entry Purchase Invoice Entry Operator Invoice Entry

  3. 2. Export Account Management Process Flow Collection Entry Operator Collection Entry Operator Payment Entry Payment Entry Operator Payment Blocking Entry Payment BlockingEntry

  4. 1.5 Account Management Screen Name Export Sales Invoice Management Menu Path Adjustment > Export Adjustment > Sales Invoice Mgmt ※ Business Description If the transport proof is registered and `Confirm` is received from HMI, a sales invoice may be issued. That is, a transport charge may be received from HMI. GLOVIS receives the sales charge and pays a purchase charge to a transport vendor. An invoice may be selectively issued based on a transport list. Moreover, an invoice requested year and month is inputted irrespective of a transport date. It is possible to cancel the invoice before a collection entry, but it is impossible to cancel the invoice after a collection entry.

  5. 1.5 Account Management Screen Name Export Sales Invoice Management Menu Path Adjustment > Export Adjustment > Sales Invoice Mgmt 1 2 3 Check ※ Definition • An invoice is issued to a transport which received `Confirm` from HMI POD after POD entry. • (`POD Confirm` I/F is received from HMI through POD I/F. And this is automatically performed at five minutes interval.) • After selecting a transport for issuing an invoice, issue the invoice by clicking [Issue] button. • This can issue an only invoice, and a registered invoice can be inquired in `Sales Settlement`. • The registered invoice can be cancelled in the `Sales Settlement Mgmt` screen. Inquiry Condition Description • POD Date : POD Entry Date. • TP Vendor (Code Popup) : Transport Vendor • TP CD : Truck Code. • HMI Lot No : Lot Number generated from HMI

  6. 1.5 Account Management Screen Name Export Sales Invoice Management Menu Path Adjustment > Export Adjustment > Sales Invoice Mgmt ※ Export Sales Invoice Issue Invoice number is automatically generated in sequence. The invoice is issued irrespective of `Payment Blocking` If a transport to be issued is selected, the amount is displayed on an upper part with a red color. Demand Month : Input a requested invoice year and month. Input month/year type such as 08/2008. The only numeral can be inputted, an error message is opened if a date type is not corrected. Confirm Password : Input and register a password.

  7. 1.5 Account Management Screen Name Monthy Export Sales Settlement Management Menu Path Adjustment > Export Adjustment > Sales Settlement Mgmt. 1 2 ※ Business Description This is linked to the invoice issue described before. This is a screen for searching, outputting, and canceling the issued invoice. Because a system generates an invoice number automatically if the invoice is issued, the invoice of a sequence number type is issued as shown above. GIN outputs the invoice, and transfers the invoice to HMI. HMI pays the transport charge. The collected money is inputted to a collection management, and is registered to a payment management to pay the transport charge to the transport vendor. Because a year and month are inputted in the invoice, the inquiry and management is performed by a month unit. An invoice amount does not include the deduction amount, and is the sum of the transport price of the transport (trip). The transport price is the sum of the transport price classified by vehicles.

  8. 1.5 Account Management Screen Name Monthly Export Sales Settlement Management Menu Path Adjustment > Export Adjustment > Sales Settlement Mgmt. 1 2 ※ Definition • An issued sales invoice is searched. • An issued sales invoice is cancelled. ① Inquiry Condition Description • Sales Month : Reference month of sales settlement by a month unit • View Condition : Select one view condition of date, vendor and deduction information. • View TP Mode : Use this when detail information including `Truck` and `Trailer` is necessary. ② Button Description • Clear : Clear an inquiry Condition. • Confirm : Sales Settlement Confirm Entry. • Cancel Cfm : Cancel `Confirm`. • Print : Open a preview window to be printed on a paper. • Excel : Download an invoice with an Excel file. • Search : Search information matched with an inquiry condition

  9. 1.5 Account Management Screen Name Monthy Export Sales Settlement Management Menu Path Adjustment > Export Adjustment > Sales Settlement Mgmt 1 2 Click ※ Definition • An inquiry is performed by a detail `Trip` unit in a detail information inquiry as shown below. ※ Process • If `Freight Amount` is clicked in the detail information inquiry, An inquiry result window of `Trip` unit is opened.

  10. 1.5 Account Management Screen Name Monthy Export Sales Settlement Management Menu Path Adjustment > Export Adjustment > Sales Settlement Mgmt ※ Definition • Output the issued sales invoice.

  11. 1.5 Account Management Screen Name Monthy Export Sales Settlement Management Menu Path Adjustment > Export Adjustment > Sales Settlement Mgt Select one ※ Definition • Download the transport information corresponding to the issued sales invoice with an Excel file. • Date : Arrival date inputted when POD is inputted with Delivery Date. • Invoice No : Invoice Number of vehicles loaded on one TP (Invoice Number is received from HMI through I/F) • Truck No : Truck Number Plate • CODE No : Truck Code • LOT No : Display five places from an back-end in `HMI-Lot-No` (e.g., a case of 00002, 2 is displayed) • QTY : Vehicle Quantity loaded on truck • Amount : Amount per truck.

  12. 1.5 Account Management Screen Name Monthy Export Sales Settlement Management Menu Path Adjustment > Export Adjustment > Sales Settlement Mgt 1 2 3 Click ※ Process Select one invoice, and cancel by clicking `Cancel Cfm` button. • An invoice which is already registered in a collection management or a payment management cannot be cancelled. • Search a registered Invoice. • Click a `Radio` button of an invoice to be cancelled. • Click ‘Cancel Cfm’ button. • Input a `Password` for the log-in of a user. • Click ‘Cancel Cfm’ button.

  13. 1.5 Account Management Screen Name Monthy Export Sales Settlement Management Menu Path Adjustment > Export Adjustment > Sales Settlement Mgt 1 Click ※ Definition • Search the deduction. • Search the registered Deduction information. • Search `View Condition` as `Deduction`. A registered vehicle is searched if `Invoice2` is clicked. • Here, A detail popup of the deduction is opened if `HMI-Lot No` is clicked. (Referring to a next page) ※ Process • Search `View Condition` as `Deduction`. • Click `HMI-Lot No` in detail information inquiry as shown below. • Open Deduction detail inquiry window Deduction Detail.

  14. 1.5 Account Management Screen name Monthly Export Sales Settlement Management Menu Path Adjustment > Export Adjustment > Sales Settlement Mgt. ※ Definition • Search detail deduction which is registered before POD • Search by a vehicle unit. • Because POD is already registered, it is impossible to modify the deduction.

  15. 1.5 Account Management Screen Name Export Purchase Invoice Management Menu Path Adjustment > Export Adjustment > Purchase Invoice Mgmt. ※ Business Description This is linked to a sales invoice described before. If sales invoice is issued, because a transport charge is received from HMI, confirm the transport charge to be paid to the transport vendor by issuing the purchase invoice. That is, if the sales invoice is not issued, the purchase invoice cannot be issued. The sales invoice is one to one relation that the transport charge is transferred from HMI to GLOVIS, but the purchase invoice is one to multi relation that the transport charge is transferred from GLOVIS to each of transport vendors. Accordingly, as shown above, a statistic data of each of transport vendors is displayed on an upper portion, and a transport list of each of the transport vendors is displayed, and the invoice is configured to be issued selectively. The purchase receives year and month irrespective of transport year and month. The invoice of the transport is issued selectively.

  16. 1.5 Account Management Screen Name Export Purchase Invoice Management Menu Path Adjustment > Export Adjustment > Purchase Invoice Mgmt. 1 2 Click ※ Definition • Register and manage purchase invoices by the invoice unit received from the transport vendor. • If a transport vendor code of an upper portion is clicked, a transport list of each of the transport vendors is displayed on a lower portion, and a settlement confirm for the transport is registered by selecting the transport to be registered and clicking [Invoice] button of a center of a screen. • An object of the purchase settlement confirm is a transport of which the sales invoice is issued. • That is, the purchase settlement can be confirmed when the sales invoice is issued. • If a requested transport is selected by a check box, a purchase amount of the selected transport is displayed on an upper portion. ① Inquiry Condition Description • POD Date : POD Entry Date • TP Vendor ( Code popup ) : Transport Vendor ② Button Description • Clear : Clear an inquiry condition. • Invoice : issue a purchase invoice.

  17. 1.5 Account Management Screen Name Export Purchase Invoice Management Menu Path Adjustment > Export Adjustment > Purchase Invoice Mgmt. ※ Process Account Confirm Number is automatically generated in sequence. The invoice is confirmed irrespective of `Payment Blocking`. If a transport to be confirmed is selected, the sum money of the selected transport is displayed by a red color. Payment Month : Input settlement year and month. e.g., Input month/year type such as 08/2008. The numeral can be inputted, an error message is opened if the input is not matched with a date type. Confirm Password : Input and register password.

  18. 1.5 Account Management Screen Name Export Purchase Invoice Management Menu Path Adjustment > Export Adjustment > Purchase Invoice Mgmt. ※ TP041 GLOVIS transport vendor As shown above, It is impossible to confirm the purchase settlement of TP041 (GLOVIS) transport vendor.

  19. 1.5 Account Management Screen Name Monthy Export Purchase Settlement Management Menu Path Adjustment > Export Adjustment > Purchase Settlement Mgmt. ※ Business Description This is linked to the purchase invoice issue. It is possible to search, output and cancel the issued purchase invoice. If the purchase invoice is issued, the transport charge can be paid to the transport vendor. Input detail money and tax through a payment management. An invoice can be cancelled before registered in a payment management, but the invoice can not be cancelled if the payment was already performed.

  20. 1.5 Account Management Screen Name Monthy Export Purchase Settlement Management Menu Path Adjustment > Export Adjustment > Purchase Settlement Mgmt. 1 2 Click ※ Process • Settlement confirm cancel. • A settlement confirm list which is already registered in a collection management or a payment management cannot be cancelled. • Search the purchase settlement confirm entry. • Click `Radio` button of the purchase settlement confirm to be cancelled. • Click ‘Cancel Cfm’ button. • Input a log-in password of a user. • Click ‘Cancel Cfm’ button.

  21. 1.5 Account Management Screen Name Monthy Export Purchase Settlement Management Menu Path Adjustment > Export Adjustment > Purchase Settlement Mgmt. ※ Excel Button • This is a function for downloading list information of an upper portion of a purchase settlement management screen.

  22. 1.5 Account Management Screen Name Uncollected Inquiry Menu Path Adjustment > Collection > Uncollected Inquiry ※ Business Description Search an invoice of which the sales invoice is issued but is not collected. That is, this is a screen for performing a collection entry by searching a collection invoice. When the purchase invoice is issued, this is available. An calculation equation of AR(Account Receivable –Sales bond) is the amount that a deduction amount is deducted from an invoice amount. A plurality of collections can be registered in one invoice for many times. In case of the collection, input a tax directly. In case of India different from Korea, people who receive money must pay the tax. The collection list can be deleted irrespective of a payment entry. The invoice of the collection entry cannot be cancelled. (It is possible to cancel the invoice after all collection lists are deleted.) An uncollected list is outputted and the payment can be requested to HMI.

  23. 1.5 Account Management Screen Name Uncollected Inquiry Menu Path Adjustment > Collection > Uncollected Inquiry ※ Definition • Input the money collected from HMI based on the invoice issued by the sales invoice. • Process an export transport and a domestic transport in one screen by having an export/domestic identifier. • It is possible to process the collection for one purchase invoice at several times. • It is possible to selectively delete the collection entry of an inquiry list of a lower portion. ([Delete] button) • Only invoice to be collected is searched, if `View All` is checked, collected invoice is searched together. • Upper Inquiry Field • AR : Invoice.Amt ㅡ Deduction.Amt ( Account Receivable : Sales Bond) • Collected : Registered Collection money • Balance : Uncollected money • Lower Inquiry Field • TDS : Tax • Receipt.Amt : Receiving Amount • Adjust.Amt : Adjustment Amount • TTL.Amt : Tax+ Receiving Amount • Cheque No : Check Number • Bank : Bank

  24. 1.5 Account Management Screen Name Collection Entry Menu Path Adjustment > Collection > Uncollected Inquiry ※ Definition • Register collection list based on the sales invoice. • AR : Invoice.Amt ㅡ Deduction.Amt ( Account Receivable : Sales bond) • Balance.Amt : AR ㅡ Collection. Amt • Voucher No : voucher Number • Cheque No : Check Number • Bank : Bank( Codes > Codes > Bank Inquiry menu registered bank) • Tax Rate : Tax Rate( If `Receipt.Amt` is inputted and a tax rate is inputted, TDS is automatically calculated.) • TDS : Tax • Receipt.Amt : Real Receipt Amount • Adjustment.Amt : Adjustment Amount • Collection.Amt : Present Collection Amount to be registered( Receipt.Amt + TDS ) • Balance.Amt : Uncollected Amount except the present collection amount( It is impossible to be smaller than Zero(0))

  25. 1.5 Account Management Screen Name Uncollected Inquiry Menu Path Adjustment > Collection > Uncollected Inquiry ※ [Delete] Button • Select and delete the collection entry.

  26. 1.5 Account Management Screen Name Uncollected Inquiry Menu Path Adjustment > Collection > Uncollected Inquiry ※ [Excel] Button • This is a function for saving the collection list screen as an Excel file.

  27. 1.5 Account Management Screen Name Uncollected Inquiry Menu Path Adjustment > Collection > Uncollected Inquiry ※ [Print] Button • This is a screen for printing the collection list screen

  28. 1.5 Account Management Screen Name Uncollected Inquiry Menu Path Adjustment > Collection > Uncollected Inquiry ※ [Receivable Aging] Button • Invoice: Display invoices from an input date to a specific date (`Inv To Date` of an inquiry condition). • Pending Term : the number of days when `Inv. DT` is deducted from `Invoice To Date` of the inquiry condition.

  29. 1.5 Account Management Screen Name Collected Inquiry Menu Path Adjustment > Collection > Collected Inquiry ※ Business Description This is a screen for searching the registered collection list. It is possible to output the collection list, and it is possible to delete the collection list which is incorrectly inputted irrespective of the payment management. Because this is a part related to the money, the collection list can be printed.

  30. 1.5 Account Management Screen Name Collected Inquiry Menu Path Adjustment > Collection > Collected Inquiry ※ Definition • The collection list is searched based on the invoice. • This is the same function with a lower inquiry portion of `Uncollected Inquiry`. • It is possible to delete the collection list by clicking [Delete] button.

  31. 1.5 Account Management Screen Name Collected Inquiry Menu Path Adjustment > Collection > Collected Inquiry ※ Definition • A voucher number, a check number, and a bank can be modified by clicking `Invoice No`.

  32. 1.5 Account Management Screen Name Collected Inquiry Menu Path Adjustment > Collection > Collected Inquiry ※ [Excel] Button • This is a function for saving the inquiry list as an Excel file.

  33. 1.5 Account Management Screen Name Collected Inquiry Menu Path Adjustment > Collection > Collected Inquiry ※ [Print] Button • This is a function for printing the collection list.

  34. 1.5 Account Management Screen Name Unpaid Inquiry Menu Path Adjustment > Payment > Unpaid Inquiry ※ Business Description This is a screen for performing a payment entry by searching an unpaid inquiry although the purchase invoice is issued to a transport vendor. The collection must be checked to perform a payment. Accordingly, the sales invoice and the collection status are displayed on an upper portion, and a payment entry is performed for the purchase invoice related to the sales invoice. (it is possible to perform the payment entry for uncollected invoice. Save an unpaid list as an Excel file, check an unpaid transport vendor list, and prepare the claim of the transport vendor. The payment for one purchase invoice is divided and registered into several times. A tax calculation of the payment management different from the collection management is complicated. The tax is different from each of transport vendors, tax types are divided into several taxes. Moreover, as described before, the payment blocking has influence on the payment management. Although an invoice is issued for a payment blocking transport, the invoice is excluded from the payment entry.

  35. 1.5 Account Management Screen Name Unpaid Inquiry Menu Path Adjustment > Payment > Unpaid Inquiry ※ Definition • This is a screen for the payment management. • This is a function for transferring a transport charge to the transport vendor. • Search a purchase invoice based on a registered sales invoice, and input an amount to be paid to the transport vendor. • An upper inquiry screen shows a sales invoice list. If an invoice number is clicked, a purchase invoice number related to the sales invoice is searched on a lower portion. • It is possible to input an amount by having [Add] button on the purchase invoice number. • It is possible to pay the amount for one purchase invoice for several times. • If a payment blocking transport is registered in `Payment Blocking`, the payment blocking transport is excluded in a payment object. • ( A list related to the payment blocking transport is not shown in an inquiry screen but an input screen.)

  36. 1.5 Account Management Screen Name Unpaid Inquiry Menu Path Adjustment > Payment > Unpaid Inquiry • Upper Inquiry Field • Sales.Inv.No : Sales Invoice Number • AP : Purch.Amt ㅡ Deduction.Amt ( Account Payable : Sales bond) • Payment: Payment Amount • Balance : Unpaid Amount • Coll. Y/N : Collection status (Collection entry of Collection Management [Collection] menu) • Lower Inquiry Field • Inv.No : Purchase Invoice Number • AP : Inv.Amt ㅡ Dedut.Amt ( Account Payable : Sales bond) • Payment : Payment Amount • Balance : Unpaid Amount • If `View All` is clicked, all invoices including a paid invoice are searched. • An invoice to be paid is searched as a basic condition.

  37. 1.5 Account Management Screen Name Payment Entry Menu Path Adjustment > Payment > Unpaid Inquiry • ※ Definition • Payment list is registered based on a purchase invoice. • AP : Invoice.Amt ㅡ Deduction.Amt ( Account Payable : Sales debt) • Balance.Amt : AP ㅡ Payment. Amt • Pay.Blck.Amt : Payment Blocking Amount • TTL.Bal.Amt : Total Unpaid Amount • Pay.Available.Amt : Payment Available Amount • Voucher No : Voucher Number • Cheque No : Check Number • Bank : Bank( Bank entry of `Codes > Codes > Bank Inquiry` menu) • TDS Rate : Tax Rate • Remittance. Amt : Remittance Amount • Adjustment. Amt : Adjustment Amount • Payment.Amt : Payment Amount • Balance.Amt : Unpaid Amount

  38. 1.5 Account Management Screen Name Unpaid Inquiry Menu Path Adjustment > Payment > Unpaid Inquiry • ※ [Excel] Button • Save a purchase invoice and a payment list related to one sales invoice number with an Excel file.

  39. 1.5 Account Management Screen Name Unpaid Inquiry Menu Path Adjustment > Payment > Unpaid Inquiry • ※ [Print] Button • Print a purchase invoice and a payment list related to one sales invoice number.

  40. 1.5 Account Management Screen Name Paid Inquiry Menu Path Adjustment > Payment > Paid Inquiry ※ Business Description This is a screen for searching, printing, and deleting the registered payment list. It is possible to delete the payment list irrespective of the collection entry. Because this part is related to the money, the payment list can be printed and saved.

  41. 1.5 Account Management Screen Name Paid Inquiry Menu Path Adjustment > Payment > Paid Inquiry ※ Definition • This is a payment management screen. • A payment amount list registered in `Unpaid Inquiry` is searched. • It is possible to modify information including a voucher, and it is possible to delete the payment list which is registered incorrectly.

  42. 1.5 Account Management Screen Name Paid Inquiry Menu Path Adjustment > Payment > Paid Inquiry ※ Definition • If an invoice number is clicked, the payment list information is displayed. • A voucher number, a check number, and a bank information can be modified.

  43. 1.5 Account Mangement Screen Name Paid Inquiry Menu Path Adjustment > Payment > Paid Inquiry ※ [Excel] Button • Save information which is not displayed by a limitation of a screen size based on the data of an inquiry screen

  44. 1.5 Account Management Screen Name Paid Inquiry Menu Path Adjustment > Payment > Paid Inquiry ※ [Print] Button • Print a payment list

  45. 1.5 Account Management BACK 1 BACK 2 Screen Name Payment Blocking Entry Menu Path Adjustment > Payment Blocking > Payment Blocking Entry ※ Business Description • Although a transport vendor completed the transport, there is a case of delaying the payment for the transport. • When a problem occurs, the payment should be not performed before the problem is solved. • It is possible to perform the payment blocking by a transport unit, and the payment blocking transport is excluded in the payment management. • However, this is not related to the invoice issue. The invoice is issued normally, and the payment blocking transport is excluded in the payment step.

  46. 1.5 Account Management Screen Name Payment Blocking Entry Menu Path Adjustment > Payment Blocking > Payment Blocking Entry ※ Definition • This is a screen for performing the payment blocking for a specific transport. • The payment blocking transport is excluded in an object of the payment management. • A table shown below is a part of the payment amount entry screen. • A red character shows the payment blocking amount which is set in a screen as shown above.

  47. 1.5 Account Management Screen Name Payment Blocking Entry Menu Path Adjustment > Payment Blocking > Payment Blocking Entry ※ Definition • It is possible to register `Blocking` when only `Block Y/N` is set to`No` and an inquiry is performed. • If `Block` button of an upper portion is clicked after a requested blocking transport is selected, as shown below, a screen for inputting the amount and the reason is displayed. • The amount can be adjusted. • [Reason Save] button is used for inputting a reason. • [Reason Skip] button is used for registering the amount without the reason. • The reason is applied to all selected transports.

  48. 1.5 Account Management Screen Name Payment Blocking Entry Menu Path Adjustment > Payment Blocking > Payment Blocking Entry ※ Definition • When `Block Y/N` is set to `Yes` and the inquiry is performed, `Blocking` can be cancelled. • If `Block` button of an upper portion is clicked after a `blocking cancel transport` is selected, as shown above, it is possible to cancel the blocking. • Although the cancel is performed, `Block.Amt` remains as a history. (a status is changed.) • As shown below, `Block Y/N` is `No` and amount is `50000`.

  49. 1.5 Account Management Screen Name Payment Blocking Entry Menu Path Adjustment > Payment Blocking > Payment Blocking Entry ※ Definition • This is a function for outputting the payment blocking list of an inquiry screen by a page unit. • ([Print] button of a upper screen)

  50. 1.5 Account Management Screen Name Payment Blocking Entry Menu Path Adjustment > Payment Blocking > Payment Blocking Entry ※ Definition • This is a function for downloading the payment blocking list of an inquiry screen with an Excel file.. ([Excel] button of an upper screen)

More Related