Project

General

Profile

Actions

Support #63

closed

"OR-" in the documentReferense in database

Added by Rhi Adrian Sabornido over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Normal
Assignee:
Start date:
07/04/2024
Due date:
% Done:

0%

Estimated time:

Description

May we request a explanation of what is "OR-" in the documentReferense in the column that sir joseph extracted from the database. Is this a AR transaction?

And may we know og bug ni or dili?


Files

photo_2024-07-04_11-41-15.jpg (137 KB) photo_2024-07-04_11-41-15.jpg Rhi Adrian Sabornido , 07/04/2024 11:41 AM
AR Transactions POS and Cloud.docx (431 KB) AR Transactions POS and Cloud.docx Egan Pido, 07/05/2024 09:24 AM
Actions #1

Updated by Rhi Adrian Sabornido over 1 year ago

Actions #2

Updated by Abegail Mae Jao over 1 year ago

  • Assignee changed from Abegail Mae Jao to Egan Pido
Actions #3

Updated by Abegail Mae Jao over 1 year ago

  • Status changed from New to In Progress
Actions #4

Updated by Egan Pido over 1 year ago

this is an AR Transaction if only "OR-". This is not a bug. I already explained this to sir Joseph

Actions #5

Updated by Egan Pido over 1 year ago

these are from POS AR sync to cloud.

Actions #6

Updated by Abegail Mae Jao over 1 year ago

  • Status changed from In Progress to Feedback
Actions #7

Updated by Redmine Admin over 1 year ago

If the sales transaction has no official receipt number, therefore this invoice is not paid yet hence you have "OR-", am I correct @Egan Pido ?

Actions #8

Updated by Egan Pido over 1 year ago

yes sir if the value is "OR-" it means this an AR from POS not a walk-in or tendered transaction. if say for example the documentreference is "OR-0000000001", it means that this record is not an AR transaction.

If you want the the AR transactions that are not yet paid or has a balance, sir Joseph can add a condition in the query "BalanceAmount > 0". Thank you

Actions #9

Updated by Egan Pido over 1 year ago

Please refer to this document

Actions #10

Updated by Abegail Mae Jao over 1 year ago

  • Status changed from Feedback to Resolved
Actions #11

Updated by Rhi Adrian Sabornido over 1 year ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF