Difference between revisions of "2. JOMPAY - How to add the Ref 2 (optional) in bank payment file format?"

From eStream Software
Jump to: navigation, search
(Created page with "<big>'''Issue:'''</big> :1. User Access control has granted to '''Show Cost in Purchase Goods Received'''. <br /> :2. Purchase Goods Received still cannot view the unit price,...")
 
Line 1: Line 1:
 
<big>'''Issue:'''</big>
 
<big>'''Issue:'''</big>
:1. User Access control has granted to '''Show Cost in Purchase Goods Received'''. <br />
+
:How to capture the JomPay Ref 2 (bill no) in bank payment file format?
:2. Purchase Goods Received still cannot view the unit price, tax amount and subtotal. <br />
+
::[[File:03-FAQ-02.jpg|800px]]
::[[File:01-FAQ-01.jpg|800px]]
 
 
<br />
 
<br />
  
 
<big>'''Solution:'''</big>  
 
<big>'''Solution:'''</big>  
:1. Point your mouse to any '''detail grid columns'''.<br />
+
:1. Go to Tools | DIY | SQL Control Center...
 +
:2. Add the JomPAY Ref2 field under '''Supplier | Supplier Payment | Payment Fields'''.  
 +
{| class="wikitable" border="1"
 +
|-
 +
! Field Name
 +
! Data Type
 +
! Size
 +
|-
 +
| JomPAY_Ref2
 +
| String
 +
| 30
 +
|}
 +
 
 +
Field name :
 +
Data Type: String
 +
Size : 30
 
::[[File:01-FAQ-02.jpg|800px]]
 
::[[File:01-FAQ-02.jpg|800px]]
 
<br />
 
<br />

Revision as of 03:35, 31 December 2019

Issue:

How to capture the JomPay Ref 2 (bill no) in bank payment file format?
03-FAQ-02.jpg


Solution:

1. Go to Tools | DIY | SQL Control Center...
2. Add the JomPAY Ref2 field under Supplier | Supplier Payment | Payment Fields.
Field Name Data Type Size
JomPAY_Ref2 String 30

Field name : Data Type: String Size : 30

01-FAQ-02.jpg


2. Right Click -> Grid Layout -> Load Layout.
01-FAQ-03.jpg


3. At Load Grid Layout, click on Reset Layout.
01-FAQ-04.jpg


4. Purchase Goods Received detail grid layout has reset follow the users access rights.
01-FAQ-05.jpg