Shipping/Forwarding: Difference between revisions

Latest revision as of 10:35, 11 October 2023

Introduction

This Customisation is the simple calculation for the Shipping/Forwarding company.

Last Customisation Update : 05 Feb 2016

Sample Database V4
Sample Database V5

Video

History New/Updates/Changes

05 Feb 2016

Fixed TaxInvoice-Fowarding2 batch print Tax summary mixing together
Fixed Quotation & Debit Note OnBeforeSave Script Seq not correct.

04 Jan 2016

Fixed TaxInvoice-Fowarding2 Title missing Tax word

07 Dec 2015

Fixed 0Sales Local - Invoice Listing - Level 1 Ent column some shown empty when 0.

02 Nov 2015

Fix Seq Error
Fix TaxInvoice-Fowarding2 format show A instead Tax Rate

20 Oct 2015

Fix Transfer Document TaxAmt calculate incorrectly if using UDF_ExRate <> 1
Fix Partial Transfer Qty TaxAmt calculate incorrectly

19 Oct 2015

Fix upgrade to Version 721 error.
Fix Transfer Document TaxAmt calculate incorrectly

14 Oct 2015

Fix 0Sales Local - Invoice Listing - Level 1 margin not correct
Convert DocRef3 to UDF_EntCost for 0Sales Local - Invoice Listing - Level 1 Ent column

Modules Require

DIY Script
DIY Field

Settings

Maintain User

Menu: Tools | Maintain User...

Untick the Access Right for Prompt Replace Unit Price Dialog under the Group : Sales

Steps

Invoice

Menu: Sales | Invoice...

01. Select Customer Code

02. Select Item Code

03. Enter the Cost incurred for the selected item code (for the Profit & Loss By Document report)

04. Enter Qty

05. Enter UnitPrice

06. Enter Exchange Rate (if had)

07. Click More tab to enter extra/others Information

Profit & Loss By Document

Menu: Sales | Print Sales Document Listing...

01. Select Invoice Listing & Range Date

02. Tick Group by Customer Code

03. Click Apply

04. Press F6 to preview

05. Select report name 0Sales Local - Invoice Listing - Level 1

06. Click Ok button

@@ Line 2: / Line 2: @@
 This Customisation is the simple calculation for the Shipping/Forwarding company.
-Last Customisation Update : 20 Oct 2015
+Last Customisation Update : 05 Feb 2016
-[http://www.estream.com.my/document/ACC%20BK-%5bShippingV4%5d.zip Sample Database]
+[https://www.sql.com.my/document/ACC%20BK-%5bShippingV4%5d.zip Sample Database V4] <br />
+[https://www.sql.com.my/document/ACC%20BK-%5bShippingV5%5d.zip Sample Database V5]
+[https://www.youtube.com/watch?v=LPoz1h3hyvQ Video]
 ===History New/Updates/Changes===
+Feb 2016
+* Fixed TaxInvoice-Fowarding2 batch print Tax summary mixing together
+* Fixed Quotation & Debit Note OnBeforeSave Script Seq not correct.
+Jan 2016
+* Fixed TaxInvoice-Fowarding2 Title missing Tax word
+Dec 2015
+* Fixed 0Sales Local - Invoice Listing - Level 1 Ent column some shown empty when 0.
+Nov 2015
+* Fix Seq Error
+* Fix TaxInvoice-Fowarding2 format show A instead Tax Rate
 Oct 2015
 * Fix Transfer Document TaxAmt calculate incorrectly if using UDF_ExRate <> 1
@@ Line 18: / Line 35: @@
 * Fix 0Sales Local - Invoice Listing - Level 1 margin not correct
 * Convert DocRef3 to UDF_EntCost for 0Sales Local - Invoice Listing - Level 1 Ent column
-Oct 2015
-* Fix OnBeforeSave Script - Partial Delivery Amount calculation revert back to system calculation
-* Fix 0Sales Local - Invoice Listing - Level 1 unable to calculate cost
-* Add 0Sales Local - Invoice Listing (GST 1) - Forwarding report
-* Add Script & UDF Field for Sales Quotation
 ==Modules Require==
@@ Line 29: / Line 40: @@
 * DIY Field
-==Setting==
+==Settings==
 ===Maintain User===
+''Menu: Tools | Maintain User...''<br />
 Untick the Access Right for '''Prompt Replace Unit Price Dialog''' under the '''Group : Sales'''
 ==Steps==
 ===Invoice===
-[[File:Shipping-01.jpg|800px]]
+''Menu: Sales | Invoice...''
+[[File:Shipping-01.jpg|800px|center]]
 :01. Select '''Customer Code'''
 :02. Select '''Item Code'''
@@ Line 43: / Line 57: @@
 :06. Enter '''Exchange Rate''' (if had)
 :07. Click '''More''' tab to enter extra/others Information
-[[File:Shipping-02.jpg|800px]]
+[[File:Shipping-02.jpg|800px|center]]
 ===Profit & Loss By Document===
-:01. Click Sales | Print Sales Document Listing...
+''Menu: Sales | Print Sales Document Listing...''
-[[File:Shipping-03.jpg|800px]]
-:02. Select '''Invoice Listing''' & Range '''Date'''
+[[File:Shipping-03.jpg|800px|center]]
-:03. Tick Group by '''Customer Code'''
+:01. Select '''Invoice Listing''' & Range '''Date'''
-:04. Click '''Apply'''
+:02. Tick Group by '''Customer Code'''
-:05. Press '''F6''' to preview
+:03. Click '''Apply'''
-:06. Select report name '''0Sales Local - Invoice Listing - Level 1'''
+:04. Press '''F6''' to preview
-:07. Click '''Ok''' button
+:05. Select report name '''0Sales Local - Invoice Listing - Level 1'''
+:06. Click '''Ok''' button
 ==See also==
 * Others [[Customisation]]