GST Margin Scheme: Difference between revisions

From eStream Software
 
(79 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<big>How To Start the New Margin Scheme Special Database?</big>
<big>How To Start the New Margin Scheme with Special Database?</big>




=='''Introduction'''==
==Introduction==
GST is normally due on the full value of goods sold. The margin scheme allows a GST Margin Scheme registered person (GST MS registered person) who meets all the conditions to calculate and charge GST on the margin i.e. the difference between the price at which the goods were obtained and the selling price. If no margin is made (because the purchase price exceeds the selling price) then no GST is charged and payable.  
:GST is normally due on the full value of goods sold. The margin scheme allows a GST Margin Scheme registered person (GST MS registered person) who meets all the conditions to calculate and charge GST on the margin i.e. the difference between the price at which the goods were obtained and the selling price. If no margin is made (because the purchase price exceeds the selling price) then no GST is charged and payable.  


For the purpose of GST, margin under this scheme means the difference between selling price and purchase price. If there is any value being added to the eligible goods such as cost for repairing, this cost is part of the margin other than profit. In other words, the value added must be included in the selling price and not the purchase price.
:For the purpose of GST, margin under this scheme means the difference between selling price and purchase price. If there is any value being added to the eligible goods such as cost for repairing, this cost is part of the margin other than profit. In other words, the value added must be included in the selling price and not the purchase price.


Therefore, we have designed a database structure specially for business which has margin scheme involvement. The modules required are:-
:Therefore, we have designed a database structure specially for business which has margin scheme involvement.
 
==Modules Require==
# SQL Accounting Basic  (GST compliance)
# SQL Accounting Basic  (GST compliance)
# DIY field
# DIY field
Line 15: Line 17:
<br />
<br />


See below the sample process flow:  
:See below the overview of Margin Scheme process flow:  
::[[File:01 GST Margin Scheme Process Flow.jpg | 30PX]]
::[[File:01 GST Margin Scheme Process Flow.jpg | 30PX]]


=='''Setup Margin Scheme Database'''==
==Setup Margin Scheme Database==
1. Get the NEW database structure for Margin Scheme (in backup format) from this link
Last Customisation Update : '''13 Sep 2016'''
http://www.sql.com.my/document/ACC%20BK-%5bMarginScheme%5d.zip
<br />
2. Restore this backup.<br />
3. Enter the user ID and password with “ADMIN” to login.<br />


:1. Get the NEW database structure for Margin Scheme (in backup format) from this link [http://www.sql.com.my/document/NEW%20COMPANY%20(For%20Margin%20Scheme)%20-%20%5bGST-MS.09.11.2016%5d%20-%202016-11-10%20-%20sqlacc.zip NEW COMPANY (For Margin Scheme)]
:2. Restore this backup.<br />
:3. Enter the user ID and password with “ADMIN” to login.<br />


=='''Setup Master Data'''==
===History New/Updates/Changes===
==='''Maintain Customer'''===
====Last Customisation Update : '''27 Nov 2015'''====
''[Customer | Maintain Customer…]''
* Move Cars Information to Maintain Project
 
* Auto Capture Initial Cost on Select Project
1. Create new buyer name (eg. company name or person name).<br />
<br />
2. Click on Tax tab to input the GST No (if applicable).<br />
====Last Customisation Update : '''20 Feb 2016'''====
::[[File:02 GST MarginScheme MaintainCustomer.jpg | 700px]]
* Empty item code (eg. repairs) will not update the Project - Purchase Details.
* Run the '''SQL Accounting Diagnosis - DB Patch''' and apply the patch files can be download from [http://www.sql.com.my/downloadfile/Fairy/Patch-MarginScheme-20160220.zip Patch-Margin Scheme-20160220.zip]
::1. Select the database file (eg.ACC-XXXXX.FDB).
::2. Drag the patch filename '''Patch-MarginScheme1'''.
::3. Click '''Execute'''.
::4. Repeat step 2 - 3  and apply with another patch filename '''Patch-MarginScheme-02-20160220'''.
<br />
====Last Customisation Update : '''08 Mar 2016'''====
* Tax amount not equal to zero. Will prompt message "Cost will be tax excluded for GST Margin purpose" after save the purchase invoice.
* Run the '''SQL Accounting Diagnosis - DB Patch''' and apply the patch files can be download from [http://www.sql.com.my/document/Patch-MarginScheme-20160308.zip Patch-MarginScheme-20160308.zip]
::1. Select the database file (eg.ACC-XXXXX.FDB).
::2. Unzip the patch file downloaded.
::3. Drag the patch filename '''DELETE_PHPI_OnAfterSave_08.03.2016'''.
::4. Click '''Execute'''.
::5. Repeat step 2 - 4  and apply with another patch filename '''UPDATE_PHPI_OnAfterSave_08.03.2016'''.
<br />
====Last Customisation Update : '''08 Aug 2016'''====
* To remove the compulsory action to select project code other than '''Default Project''' (----).
* Run the '''SQL Accounting Diagnosis - DB Patch''' and apply the patch files can be download from http://www.sql.com.my/document/Patch-MarginScheme-20160808.zip
::1. Select the database file (eg.ACC-XXXXX.FDB).
::2. Unzip the patch file downloaded.
::3. Drag the patch filename '''DELETE_SLIV_OnBeforerSave_2016.08.08'''.
::4. Click '''Execute'''.
<br />
====Last Customisation Update : '''13 Sep 2016'''====
* Margin Scheme options added in Maintain Project. It is allow to determine the car sold using GST margin scheme or GST standard calculation.
* Run the '''SQL Accounting Diagnosis - DB Patch''' and apply the patch files can be download from http://www.sql.com.my/document/Patch-MarginScheme-20160913.zip
::1. Select the database file (eg.ACC-XXXXX.FDB).
::2. Unzip the patch file downloaded.
::3. Drag the patch filename '''DELETE_SLIV_OnGridColValChg_2016.09.13'''.
::4. Click '''Execute'''.
::5. Repeat step 2 - 4  and apply with another patch filename '''INSERT_SLIV_OnGridColValChg_2016.09.13'''.
* Add new field name '''MS''' in Maintain Project.
::1. Go to Tools | DIY | SQL Control Center...
::2. Browse to Business Objects | Miscellaneous | '''Project''' | Project Fields
::[[File:09_GST MarginScheme_Update_20160913_01.jpg | 800px]]
<br />
::3. Add new field name '''MS''' and the Data Type, Size, Sub Size, Caption, etc must follow the screenshot below. Click to Save button.
::[[File:09_GST MarginScheme_Update_20160913_02.jpg | 800px]]
<br />
::4. Next, click on the existing '''Margin Scheme''' form. See the screenshot below.
::[[File:09_GST MarginScheme_Update_20160913_03.jpg | 800px]]
<br />
::5. Click on '''Customize''' button.
::[[File:09_GST MarginScheme_Update_20160913_04.jpg | 800px]]
<br />
::6. Drag the '''Margin Scheme''' from Available Item list and drop under Purchase Details. See screenshow below.
::[[File:09_GST MarginScheme_Update_20160913_05.jpg | 800px]]
<br />
::7. Lastly, click to Save button.
::[[File:09_GST MarginScheme_Update_20160913_06.jpg | 800px]]
<br />
<br />


3. Click on extra tab. You can enter the road tax, inspection and insurance reminder date for reference.<br />
'''NOTE:'''
::[[File:02 GST MarginScheme MaintainCustomer Extra.jpg | 700px]]<br />
Patch files are applicable to old margin scheme database.
 
==='''Maintain Supplier'''===
''[Supplier | Maintain Supplier…]''


1. Create new seller name (eg. company name or person name).<br />
2. Click on Tax tab to input the GST No (if applicable).<br />
::[[File:03 GST MarginScheme MaintainSupplier.jpg | 700px]]
<br />
<br />


==='''Maintain Stock Item'''===
====<big>Last Customisation Update : '''09 Nov 2016'''</big>====
''[Stock | Maintain Stock Item…]''
* Added '''Stock Book Number''' into Maintain Project. It will auto update project '''Stock Book Number''' key-in at purchase invoice '''Ext. No'''.
1. Create the car model at Maintain Stock Item. For example, TOYOTA VIOS 1.5G(AT)<br />
* '''Fixed the bug update project from Purchase Invoice on the First line only.'''
2. Click on Vehicle tab to define this item is a "Vehicle".<br />
* Run the '''SQL Accounting Diagnosis - DB Patch''' and apply the patch files can be download from http://www.sql.com.my/document/Patch-MarginScheme-20161109.zip
::[[File:04 GST MarginScheme MaintainStockItem Vehicle.jpg | 30PX]]
::1. Select the database file (eg.ACC-XXXXX.FDB).
::2. Unzip the patch file downloaded.
::3. Drag the patch filename '''DELETE_PHPI_OnAfterSave_2016.11.09'''.
::4. Click '''Execute'''.
::5. Repeat step 2 - 4  and apply with another patch filename '''INSERT_PHPI_OnAfterSave_2016.11.09'''.
* Add new field name '''StkBookNo''' in Maintain Project.
::1. Go to Tools | DIY | SQL Control Center...
::2. Browse to Business Objects | Miscellaneous | '''Project''' | Project Fields
::[[File:10_GST MarginScheme_Update_20161109_01.jpg | 800px]]
<br />
<br />
 
::3. Add new field name '''StkBookNo''' and the Data Type, Size, Sub Size, Caption, etc '''must follow the screenshot below'''. Click to Save button.
==='''Maintain Project'''===
::[[File:10_GST MarginScheme_Update_20161109_02.jpg | 800px]]
''[Stock | Maintain Project…]''
1. Create the second car plate number in Maintain Project.<br />
2. Update the Vehicle detail.<br />
::[[File:05 GST MarginScheme MaintainProject VehicleDetail.jpg | 140PX]]
<br />
<br />
3. Leave BLANK to Purchase Invoice Date, Purchase Invoice No and Cost. It will auto update when you are select the project code and save at the Purchase Invoice.<br />
::4. Next, click on the existing '''Margin Scheme''' form. See the screenshot below.
::[[File:05 GST MarginScheme MaintainProject PurchaseDetail.jpg | 30PX]]
::[[File:10_GST MarginScheme_Update_20161109_03.jpg | 800px]]
<br />
<br />
 
::5. Click on '''Customize''' button.
==''Record Purchase of Second Hand Car Value''==
::[[File:10_GST MarginScheme_Update_20161109_04.jpg | 800px]]
''[Purchase | Purchase Invoice…]''
 
1. Enter the purchase value of second car at Purchase Invoice. (eg. RM75,000)
2. You must select the correct car plate number from Project. (eg. PGE3333)
3. Purchase invoice number, date and cost will be auto updated after you have save the purchase invoice. <br />
<br />
<br />
::6. Drag the '''Stock Book No''' from Available Item list and drop under Purchase Details. See screenshow below.
::[[File:10_GST MarginScheme_Update_20161109_05.jpg | 800px]]
<br />
<br />
''NOTE : This information is required to show in Lampiran 07 -Monthly Report for Relief for Secondhand Goods or Margin Scheme (MS)''<br />
::7. Lastly, click to Save button.
 
::[[File:10_GST MarginScheme_Update_20161109_06.jpg | 800px]]
::[[File:PD-Job Order-Save JO.jpg | 440PX]]
 
<br />
<br />


=='''AFTER SAVE - JO Check on the Available Stock Balance'''==
'''NOTE:'''
1. HIGHLIGHT on the component items and PRESS on F11 keyboard button (Available Stock Balance).  
Patch files are applicable to old margin scheme database.


2. Below is component “FRAME” stock available balance,
==Setup Master Data==
 
===Maintain Customer===
::[[File:PD-Job Order-AvailableBal-01s.jpg | 440PX]]
''[Customer | Maintain Customer…]''
 
'''Result for component “FRAME” item:'''
SO Qty = 0.00
PO Qty = 0.00
JO Qty = -6.00
Qty (On Hand) = 0.00
Available Qty = -6.00
'''NOTE: Qty (On Hand) results above are trying to show the stock movement purpose only.'''


:1. Create new buyer name (eg. company name or person name).<br />
:2. Click on Tax tab to input the GST No (if applicable).<br />
::[[File:02 GST MarginScheme MaintainCustomer.jpg | 700px]]
<br />
<br />


3. Below is component “WHEEL” stock available balance,  
:3. Click on extra tab. You can enter the road tax, inspection and insurance reminder date for reference.<br />
::[[File:02 GST MarginScheme MaintainCustomer Extra.jpg | 700px]]<br />


::[[File:PD-Job Order-AvailableBal-02s.jpg | 440PX]]
===Maintain Supplier===
''[Supplier | Maintain Supplier…]''


'''Result for component “WHEEL” item:'''
:1. Create new seller name (eg. company name or person name).<br />
SO Qty = 0.00
:2. Click on Tax tab to input the GST No (if applicable).<br />
PO Qty = 0.00
::[[File:03 GST MarginScheme MaintainSupplier.jpg | 700px]]
JO Qty = -24.00
<br />
Qty (On Hand) = 0.00
Available Qty = -24.00
'''NOTE: Qty (On Hand) results above are trying to show the stock movement purpose only.'''


===Maintain Stock Item===
''[Stock | Maintain Stock Item…]''
:1. Create the car model at Maintain Stock Item. For example, TOYOTA VIOS 1.5G(AT)<br />
:2. Click on Vehicle tab to define this item is a "Vehicle".<br />
::[[File:04 GST MarginScheme MaintainStockItem Vehicle.jpg | 30PX]]
<br />
<br />


4. Below is component “ENGINE” stock available balance,
===Maintain Project===
 
''[Tools | Maintain Project…]''
::[[File:PD-Job Order-AvailableBal-03s.jpg | 440PX]]
:1. Create the second car plate number in Maintain Project.<br />
 
:2. Update the Vehicle detail.<br />
'''Result for component “ENGINE” item:'''
::[[File:05 GST MarginScheme MaintainProject VehicleDetail.jpg | 100PX]]
SO Qty = 0.00
<br />
PO Qty = 0.00
:3. Tick on '''Margin Scheme''' if it is a second hand car plate number.
JO Qty = -6.00
::[[File:05_GST MarginScheme_MaintainProject_PurchaseDetail_MS.jpg | 100PX]]
Qty (On Hand) = 0.00
<br />
Available Qty = -6.00
:4. Leave BLANK to Purchase Invoice Date, Purchase Invoice No and Cost. It will auto update when you are select the project code and save at the Purchase Invoice.<br />
'''NOTE: Qty (On Hand) results above are trying to show the stock movement purpose only.'''
::[[File:05 GST MarginScheme MaintainProject PurchaseDetail.jpg | 30PX]]
 
<br />
<br />


=='''Split to X Process'''==
==Record Purchase of Second Hand Car Value==
1. With this field, user able to assign number of processes/machines in one Job Order/Stock Item Assembly to produce same End Products using same range of BOM components.
''[Purchase | Purchase Invoice…]''
 
::[[File:PD-Job Order-Split to Process.jpg | 440PX]]
2. For example,
To make a cup of MILO KAO KAO, it needs
- MILO Powder x 5 spoons
- Sugar x 0.5 spoon
- Water x 100ml
In order to make 100 cups of milo from one Job Order created, we need 10 persons to make it more efficient. Therefore, we have to input "Split to 10 process(s)", it means 10 persons processing.
Job Order will be break the BOM components into 10 processes like below:
 
{| class="wikitable"
|-
! '''No of process(s)''' !! '''1''' !! '''2''' !! '''3''' !! '''4''' !! '''5''' !! '''6''' !! '''7''' !! '''8''' !! '''9''' !! '''10''' !! TOTAL
|-
| MILO Powder || 50 || 50 || 50 || 50 || 50 || 50 || 50 || 50 || 50 || 50 || 500 spoons
|-
| Sugar || 5 || 5 || 5 || 5 || 5 || 5 || 5 || 5 || 5 || 5 || 50 spoons
|-
| Water || 1000 || 1000 || 1000 || 1000 || 1000 || 1000 || 1000 || 1000 || 1000 || 1000 || 10000 ml
|}
 
'''NOTE: Preview and select the standard report name "Job Order 2 with Multipler - 30 Columns (without cost)".'''
 
<br />


=='''Show Multilevel BOM in Flat Mode'''==
:1. Enter the purchase value of second car at Purchase Invoice. (eg. RM30,000 )<br />
1. This function ables to drill down to the flatten or deepest level of the BOM structure. For example, the CAR multilevel BOM structure.
:2. You must select the correct car plate number from Project. (eg. PGE3333, AAA9999)<br />
{| class="wikitable"
:3. Supplier GST No, Purchase invoice number, date and cost will be update automatically after you have save the purchase invoice. <br />
|-
::{| class="wikitable"
! '''Level 0''' !! '''Level 1''' !! '''Level 2''' !! '''Level 3'''
|-
|-
| Car || Frame || Front Frame || Orange
! Project: Purchase Detail !! Update from
|-
|-
| Car || Frame || Front Frame || Screw
| Supplier GST No || Maintain Supplier '''(GST No)'''
|-
|-
| Car || Frame || Back Frame || Red Light
| Purchase Invoice No || Purchase Invoice '''(Doc No)'''
|-
|-
| Car || Frame || Back Frame || Screw
| Purchase Invoice Date || Purchase Invoice '''(Doc Date)'''
|-
|-
| Car || Wheel || Rim ||  
| Cost || Purchase Invoice '''(Unit Price)'''
|-
|-
| Car || Wheel || Tyres ||
| Stock Book No. || Purchase Invoice '''(Ext No)'''
|-
| Car || Engine || Engine Block || Filter
|-
| Car || Engine || Engine Block || Screw
|-
| Car || Engine || Piston || Tube
|-
| Car || Engine || Piston || Cover
|-
| Car || Labour ||  ||  
|}
|}
<br />


::[[File:06 GST MarginScheme Purchase Invoice.jpg | 440PX]]
<br />


2. Before FLAT mode, the BOM components shown at LEVEL 1.


::[[File:PD-Job Order-Show Multilevel BOM.jpg | 440PX]]
'''NOTE : '''<br />
1. This information is required to show in Lampiran 07 -Monthly Report for Relief for Secondhand Goods or Margin Scheme (MS).<br />
2. Auto update to project purchase detail (Purchase No, Purchase Date and Cost) if tax amount is zero.<br />




3. CLICK on Show Multilevel BOM in Flat Mode button. It will prompted a message. See below screenshot.
<br />


::[[File:PD-Job Order-Show,Multilevel BOM-Message.jpg | 440PX]]
==Record Sale of Second Hand Car Value==
''[Sales | Invoice…]''<br />
===Margin Scheme Input===


* '''PRESS NO''' to remain the BOM components at '''LEVEL 1'''.
:1. Enter the sale value of second car at Invoice. (eg.RM90,113.69)<br />
* '''PRESS YES''' to flatten the multilevel BOM till '''LEVEL 3'''.
:2. You must select the correct car plate number from Project.(eg.PGE3333)<br />
:3. Initial Purchase Cost will auto upadate after select the project (car plate number). <br />
:4. Tax amount will be calculated based on Margin Scheme method.(See screenshot below)<br />
::a. Sellng Price = 90,113.69<br />
::b. Purchase Cost = 30,000.00<br />
::c. Margin = 90,113.69 – 30,000.00 = 60,113.69<br />
::d. Tax amount = 60,113.69 x 6/106 = 3,402.66<br />


::[[File:07 GST MarginScheme SalesInvoice.jpg | 440PX]]
<br />


4. After FLAT mode, the BOM components will be shown at LEVEL 3.
:6. Invoice no, invoice date, selling price, margin, and margin tax amount will be shown in Lampiran 07 -Monthly Report for Relief for Secondhand Goods or Margin Scheme (MS)<br />


::[[File: PD-Job Order-Flat mode.jpg | 440PX]]
===Other Information===


:1. Customer Particular tab.<br />
::[[File:07 GST MarginScheme SalesInvoice CustParticular.jpg | 440PX]]
<br />
:2. Deposit Info (For record purpose, no posting to account).<br />
::[[File:07 GST MarginScheme SalesInvoice Deposit.jpg | 440PX]]
<br />
:3. Vehichle Detail (Auto retrieve from Vehicle Detail in Maintain Project).<br />
::[[File:07 GST MarginScheme SalesInvoice VehicleDetail.jpg | 440PX]]
<br />
<br />


=='''BOM Tree Entry'''==
==Print for GST Lampiran 07 (Lampiran B0-Penyata-Pemantauan-SM-Syarikat)==
1. Some manufacturing company need to modify and overwrite the standard BOM structure during the entry stage. This button is help to add/remove the components to overwrite the BOM structure.
''[Sales | Print Sales Document Listing…]''
 
2. Click the "BOM Tree Entry" button.
::[[File:PD-Job Order-BOM Tree Entry.jpg | 440PX]]


:1. Select document to “Invoice Listing” and click APPLY.<br />
::[[File:08 GST MarginScheme SalesDocumentListing.jpg | 440PX]]
<br />
<br />
 
:2. Click on preview or print. Select the report name “Lampiran B0-Penyata-Pemantauan-SM-Syarikat”.<br />
3. You can drill down all the BOM structure.
::[[File:08 GST MarginScheme SalesDocumentListingLampiran B.jpg | 40PX]]
 
4. Tick the components in the tree you wish to insert into the Job Order/Stock Assembly/Disassembly.
 
5. Press OK to confirm.
::[[File:PD-Job Order-BOM Tree Entry 2.jpg | 440PX]]
 
<br />
<br />


{| class="wikitable"
==See also==
|-
* Others [[Customisation]]
! '''Button''' !! '''Function'''
|-
| Add || To add new components at LEVEL 1 ONLY
|-
| Add Child || To add new child components start from LEVEL 2 onwards
|-
| Delete || To remove the components at all LEVEL 1, 2, 3, 4, ...
|}
 
<br />

Latest revision as of 06:27, 10 November 2016

How To Start the New Margin Scheme with Special Database?


Introduction

GST is normally due on the full value of goods sold. The margin scheme allows a GST Margin Scheme registered person (GST MS registered person) who meets all the conditions to calculate and charge GST on the margin i.e. the difference between the price at which the goods were obtained and the selling price. If no margin is made (because the purchase price exceeds the selling price) then no GST is charged and payable.
For the purpose of GST, margin under this scheme means the difference between selling price and purchase price. If there is any value being added to the eligible goods such as cost for repairing, this cost is part of the margin other than profit. In other words, the value added must be included in the selling price and not the purchase price.
Therefore, we have designed a database structure specially for business which has margin scheme involvement.

Modules Require

  1. SQL Accounting Basic (GST compliance)
  2. DIY field
  3. DIY script
  4. Project (use to record Car Plate number)


See below the overview of Margin Scheme process flow:
30PX

Setup Margin Scheme Database

Last Customisation Update : 13 Sep 2016

1. Get the NEW database structure for Margin Scheme (in backup format) from this link NEW COMPANY (For Margin Scheme)
2. Restore this backup.
3. Enter the user ID and password with “ADMIN” to login.

History New/Updates/Changes

Last Customisation Update : 27 Nov 2015

  • Move Cars Information to Maintain Project
  • Auto Capture Initial Cost on Select Project


Last Customisation Update : 20 Feb 2016

  • Empty item code (eg. repairs) will not update the Project - Purchase Details.
  • Run the SQL Accounting Diagnosis - DB Patch and apply the patch files can be download from Patch-Margin Scheme-20160220.zip
1. Select the database file (eg.ACC-XXXXX.FDB).
2. Drag the patch filename Patch-MarginScheme1.
3. Click Execute.
4. Repeat step 2 - 3 and apply with another patch filename Patch-MarginScheme-02-20160220.


Last Customisation Update : 08 Mar 2016

  • Tax amount not equal to zero. Will prompt message "Cost will be tax excluded for GST Margin purpose" after save the purchase invoice.
  • Run the SQL Accounting Diagnosis - DB Patch and apply the patch files can be download from Patch-MarginScheme-20160308.zip
1. Select the database file (eg.ACC-XXXXX.FDB).
2. Unzip the patch file downloaded.
3. Drag the patch filename DELETE_PHPI_OnAfterSave_08.03.2016.
4. Click Execute.
5. Repeat step 2 - 4 and apply with another patch filename UPDATE_PHPI_OnAfterSave_08.03.2016.


Last Customisation Update : 08 Aug 2016

1. Select the database file (eg.ACC-XXXXX.FDB).
2. Unzip the patch file downloaded.
3. Drag the patch filename DELETE_SLIV_OnBeforerSave_2016.08.08.
4. Click Execute.


Last Customisation Update : 13 Sep 2016

1. Select the database file (eg.ACC-XXXXX.FDB).
2. Unzip the patch file downloaded.
3. Drag the patch filename DELETE_SLIV_OnGridColValChg_2016.09.13.
4. Click Execute.
5. Repeat step 2 - 4 and apply with another patch filename INSERT_SLIV_OnGridColValChg_2016.09.13.
  • Add new field name MS in Maintain Project.
1. Go to Tools | DIY | SQL Control Center...
2. Browse to Business Objects | Miscellaneous | Project | Project Fields
09 GST MarginScheme Update 20160913 01.jpg


3. Add new field name MS and the Data Type, Size, Sub Size, Caption, etc must follow the screenshot below. Click to Save button.
09 GST MarginScheme Update 20160913 02.jpg


4. Next, click on the existing Margin Scheme form. See the screenshot below.
09 GST MarginScheme Update 20160913 03.jpg


5. Click on Customize button.
09 GST MarginScheme Update 20160913 04.jpg


6. Drag the Margin Scheme from Available Item list and drop under Purchase Details. See screenshow below.
09 GST MarginScheme Update 20160913 05.jpg


7. Lastly, click to Save button.
09 GST MarginScheme Update 20160913 06.jpg


NOTE:
Patch files are applicable to old margin scheme database.


Last Customisation Update : 09 Nov 2016

  • Added Stock Book Number into Maintain Project. It will auto update project Stock Book Number key-in at purchase invoice Ext. No.
  • Fixed the bug update project from Purchase Invoice on the First line only.
  • Run the SQL Accounting Diagnosis - DB Patch and apply the patch files can be download from http://www.sql.com.my/document/Patch-MarginScheme-20161109.zip
1. Select the database file (eg.ACC-XXXXX.FDB).
2. Unzip the patch file downloaded.
3. Drag the patch filename DELETE_PHPI_OnAfterSave_2016.11.09.
4. Click Execute.
5. Repeat step 2 - 4 and apply with another patch filename INSERT_PHPI_OnAfterSave_2016.11.09.
  • Add new field name StkBookNo in Maintain Project.
1. Go to Tools | DIY | SQL Control Center...
2. Browse to Business Objects | Miscellaneous | Project | Project Fields
10 GST MarginScheme Update 20161109 01.jpg


3. Add new field name StkBookNo and the Data Type, Size, Sub Size, Caption, etc must follow the screenshot below. Click to Save button.
10 GST MarginScheme Update 20161109 02.jpg


4. Next, click on the existing Margin Scheme form. See the screenshot below.
10 GST MarginScheme Update 20161109 03.jpg


5. Click on Customize button.
10 GST MarginScheme Update 20161109 04.jpg


6. Drag the Stock Book No from Available Item list and drop under Purchase Details. See screenshow below.
10 GST MarginScheme Update 20161109 05.jpg


7. Lastly, click to Save button.
10 GST MarginScheme Update 20161109 06.jpg


NOTE:
Patch files are applicable to old margin scheme database.

Setup Master Data

Maintain Customer

[Customer | Maintain Customer…]

1. Create new buyer name (eg. company name or person name).
2. Click on Tax tab to input the GST No (if applicable).
02 GST MarginScheme MaintainCustomer.jpg


3. Click on extra tab. You can enter the road tax, inspection and insurance reminder date for reference.
02 GST MarginScheme MaintainCustomer Extra.jpg

Maintain Supplier

[Supplier | Maintain Supplier…]

1. Create new seller name (eg. company name or person name).
2. Click on Tax tab to input the GST No (if applicable).
03 GST MarginScheme MaintainSupplier.jpg


Maintain Stock Item

[Stock | Maintain Stock Item…]

1. Create the car model at Maintain Stock Item. For example, TOYOTA VIOS 1.5G(AT)
2. Click on Vehicle tab to define this item is a "Vehicle".
30PX


Maintain Project

[Tools | Maintain Project…]

1. Create the second car plate number in Maintain Project.
2. Update the Vehicle detail.
100PX


3. Tick on Margin Scheme if it is a second hand car plate number.
100PX


4. Leave BLANK to Purchase Invoice Date, Purchase Invoice No and Cost. It will auto update when you are select the project code and save at the Purchase Invoice.
30PX


Record Purchase of Second Hand Car Value

[Purchase | Purchase Invoice…]

1. Enter the purchase value of second car at Purchase Invoice. (eg. RM30,000 )
2. You must select the correct car plate number from Project. (eg. PGE3333, AAA9999)
3. Supplier GST No, Purchase invoice number, date and cost will be update automatically after you have save the purchase invoice.
Project: Purchase Detail Update from
Supplier GST No Maintain Supplier (GST No)
Purchase Invoice No Purchase Invoice (Doc No)
Purchase Invoice Date Purchase Invoice (Doc Date)
Cost Purchase Invoice (Unit Price)
Stock Book No. Purchase Invoice (Ext No)


440PX



NOTE : 
1. This information is required to show in Lampiran 07 -Monthly Report for Relief for Secondhand Goods or Margin Scheme (MS).
2. Auto update to project purchase detail (Purchase No, Purchase Date and Cost) if tax amount is zero.



Record Sale of Second Hand Car Value

[Sales | Invoice…]

Margin Scheme Input

1. Enter the sale value of second car at Invoice. (eg.RM90,113.69)
2. You must select the correct car plate number from Project.(eg.PGE3333)
3. Initial Purchase Cost will auto upadate after select the project (car plate number).
4. Tax amount will be calculated based on Margin Scheme method.(See screenshot below)
a. Sellng Price = 90,113.69
b. Purchase Cost = 30,000.00
c. Margin = 90,113.69 – 30,000.00 = 60,113.69
d. Tax amount = 60,113.69 x 6/106 = 3,402.66
440PX


6. Invoice no, invoice date, selling price, margin, and margin tax amount will be shown in Lampiran 07 -Monthly Report for Relief for Secondhand Goods or Margin Scheme (MS)

Other Information

1. Customer Particular tab.
440PX


2. Deposit Info (For record purpose, no posting to account).
440PX


3. Vehichle Detail (Auto retrieve from Vehicle Detail in Maintain Project).
440PX


Print for GST Lampiran 07 (Lampiran B0-Penyata-Pemantauan-SM-Syarikat)

[Sales | Print Sales Document Listing…]

1. Select document to “Invoice Listing” and click APPLY.
440PX


2. Click on preview or print. Select the report name “Lampiran B0-Penyata-Pemantauan-SM-Syarikat”.
40PX


See also